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
JohnMac328Asked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.