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

Posted on 2011-04-28
Medium Priority
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

peter57r earned 2000 total points
ID: 35483243
In the criteria cell...

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

Author Closing Comment

ID: 35483390
Thank You !

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
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 Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

850 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