Allow blanks in Prompt

J

jhicsupt

I have a query that prompts for value. I need to include blanks. I am using
the below. If user presses OK, I need to include all records, even if field
is blank.

Like [Enter Owner or press OK for ALL: ] & "*"
 
W

Wayne-I-M

Add 2 Criterias

1st criteria
Like [Enter Owner or press OK for ALL ]

2nd criteria
Like [Enter Owner or press OK for ALL ] Is Null
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prompt to include all records or choose just some records 1
not equal query 3
Eliminate blanks while copy row and transpose 11
Update queries with form (trying to avoid error) 1
ghost prompt 2
DSUM with dates 1
Blanks 5
Filter (blanks) with two or more unique values not working 1

Top