query variables

  • Thread starter Thread starter Wuffles
  • Start date Start date
W

Wuffles

As a test I am trying to use variables in a table query. In the query design
criteria numeric field if I place >10 the query filters OK, but if I put a
variable in the criteria the query asks me in a box for a value for that
variable and if I type >10 it does not work.

What I am actually trying to do is define the criteria using variables from
a form through a forms!xxxx!variable entry in the criteria of the table
query. Variable = "10" works but variable= ">10" does not.

Please help if you can. Thank you.
 
As a test I am trying to use variables in a table query. In the query design
criteria numeric field if I place >10 the query filters OK, but if I put a
variable in the criteria the query asks me in a box for a value for that
variable and if I type >10 it does not work.

What I am actually trying to do is define the criteria using variables from
a form through a forms!xxxx!variable entry in the criteria of the table
query.  Variable = "10" works but  variable= ">10" does not.

Please help if you can.  Thank you.
Click to expand...

Makes sense... 10 is a number... >10 is a STRING. Big difference.

you cannot specify operators in the query criteria the way you are
attempting to. If you want to filter result sets on the fly, you have
two options (maybe more... but I can only think of two at the
moment)...
1. modify the query's SQL statement on the fly and saving it, then
opening the query.
2. create a report based on the unfiltered query, build the filter in
your unbound form (referencing whatever controls you wish), and
passing that filter in the open event of the report.
 
What I am actually trying to do is define the criteria using variables from
a form through a forms!xxxx!variable entry in the criteria of the table
query. Variable = "10" works but variable= ">10" does not.
Click to expand...

You can pass *values* in a parameter - but you cannot pass *operators* such as
or BETWEEN or LIKE. If you need to allow users that flexibility, you'll need
Click to expand...
two (or more) controls - perhaps a combo box offering the operators
< <= = >= >, and a textbox for the value. You'll need VBA code to actually
construct the SQL of the query.
 
Back
Top