• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 421
  • Last Modified:

Access 2010 - Parameter query

I have a parameter query that has begin date and end date, ticker symbol and broker.  If I give a value for all of them then it works fine.  If I don't enter a broker name it does not give any records which it would if the query was setup to just ask for date range and ticker symbol.  How do I change the query in design view to only include the parameter value if there is one entered in the popup window?

Thanks,
John
0
JohnMac328
Asked:
JohnMac328
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
John,

<<How do I change the query in design view to only include the parameter value if there is one entered in the popup window?>>

  Change the criteria check to:

 =[Parma Name] or [Param Name] is null

  When you save the query, Access will reformat it, but it will still work.

Jim.
0
 
JohnMac328Author Commented:
Great - Thanks
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Tackle projects and never again get stuck behind a technical roadblock.
Join Now