interactive query

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

Guest

Hello

If I make the following query

field: cost
criteria: >[give a minimum value

What do I typ in the msgbox to see all data (all the costs)
With a string I can use a "*" but it doesn't work with values

Thank
Tac
 
Dear Taco:

Using the code I suggested before, the user can just press return
without typing anything at all to ignore this filter.

If you have any other filters set up for this query, possibly with
AND, then using the Query Design Grid becomes rather difficult when
adding an OR criterion. Using SQL directly for this, with parentheses
around the code for this one filter, is very useful at that point.
So, in order to make my solution fit in all possible conditions, I
gave you the code for it rather than showing how it goes into the
grid.

You can put the two parts of this filter in the grid if you have no
other filters.

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