PARAMETER CRITERIA

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

Guest

i have created a query based on another query combining data from multiple tables

i want to create a parameter criteria for a specific field but it doesn't work! i have tried the same thing with other similar fields and it works very well. what may be wrong with the particular field?
 
Tell me more about this particular field. Does this field
pull straight from a table, or from the other query? If the
latter, is the field a calculated field, or different in
any way? Have you checked to make sure that the criteria
you input is actually something that can be found in this
field? (i.e. run the query without a criteria in place for
this field, and you see the value you're searching for, but
it won't work when you've got the parameter in your
criteria) Have you tried multiple values and none of them
work? Have you tried running the query without this field
at all, and it works correctly?
-----Original Message-----
i have created a query based on another query combining data from multiple tables.

i want to create a parameter criteria for a specific field
Click to expand...
but it doesn't work! i have tried the same thing with other
similar fields and it works very well. what may be wrong
with the particular field?
 
Back
Top