Access 2010 - Parameter query

Posted on 2011-10-03
Last Modified: 2012-05-12
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?

Question by:JohnMac328
    LVL 56

    Accepted Solution


    <<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.


    Author Closing Comment

    Great - Thanks

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now