Parameter query which defaults to all records - possible?

[What-A-Tool]

I have a parameter query which prompts a user for an entry - if nothing is
entered, I would like the query to then show ALL records.

Is this possible?

Thanks in advance for any help -
Sean

[fredg]

On Mon, 9 Apr 2007 17:00:25 -0400, What-A-Tool wrote:

I have a parameter query which prompts a user for an entry - if nothing is
entered, I would like the query to then show ALL records.

Is this possible?

Thanks in advance for any help -
Sean

As criteria on that column, write
[What do you want?]
On the column's Or row, write:
[What do you want?] is null
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[What-A-Tool]

"fredg" <fg******@example.invalidwrote in message
news:mm*****************************@40tude.net...

On Mon, 9 Apr 2007 17:00:25 -0400, What-A-Tool wrote:

>I have a parameter query which prompts a user for an entry - if nothing
is
entered, I would like the query to then show ALL records.

Is this possible?

Thanks in advance for any help -
Sean

As criteria on that column, write
[What do you want?]
On the column's Or row, write:
[What do you want?] is null
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Awesome - I've been scouring the internet and my books, and I could not find
any references on a way to do this.

Thank you very much - worked like a charm!
Sean