Parameter Query (2000)

Topic

New Reply

I have created a Select Query that is set up so the user can type in a range of account numbers and a department number. The result is all accounts in that range that are assigned to the requested department. So far, so good. However, there are times when what is needed is all accounts in that range, no department designated. The query as it stands comes up blank if no department. is designated. Right now I have a separate query for accounts only. Is there a way to make one query work for both situations?

Reply | Quote

Replies

Hans has supplied this solution before, so your WHERE clause should probably look like:
WHERE Department like [Enter Department] & “*”
or:
WHERE Department like [Enter Department] or [Enter Department] is Null

Pat

Reply | Quote

Oh, I’m going to LOVE this site. It does exactly what I wanted

Reply | Quote