interactive query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
I hope someone can help me,
I am looking for a solution to see all the records in an interactive query
for example: >[value
then there is the msgBox that asks me for a valu
What should I Type to get all records

Thank
Taco
 
Dear Taco:

If you change your query so this column is:
[value]
Click to expand...
OR
[value] IS NULL

Then the user can just ENTER for the prompt and get all values.

If this isn't apparent for you, provide the text of your SQL I could
be more specific to your setup.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


Hello,
I hope someone can help me,
I am looking for a solution to see all the records in an interactive query.
for example: >[value]
then there is the msgBox that asks me for a value
What should I Type to get all records!

Thanks
Taco
Click to expand...
 
Back
Top