I would like to see all records returned on a query using Access 2010

Posted on 2011-04-28
Last Modified: 2012-05-11
I have a query that looks for a value on a form "IFLOC"
and depending on the value present it returns records associated to the value.
The problem I have is if I don't specfy a value then no records are retrieved. What can be added below so that if no value is present in field "IFLOC" then all records are returned as a result.

[Forms]![Master Form]![IFLOC]

Question by:_Hector
    LVL 77

    Accepted Solution

    In the criteria cell...

    [Forms]![Master Form]![IFLOC] or ([Forms]![Master Form]![IFLOC] is null)

    Author Closing Comment

    Thank You !

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    734 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

    21 Experts available now in Live!

    Get 1:1 Help Now