problem with multiple criteria select query...?

J

JDA

Hi,

I am having a problem setting up multiple critera with a select query I'm
writing, and I'm not sure what I'm doing wrong:

there are three fields that I am trying to select critera on - two are text
fields and one is a date field. when I use "like *abc" for the text fields,
the proper records are selected. when I use "like *abc" and then
#1/1/2004#, the query does not filter the dates properly (at all). If I
Click to expand...
only filter the date, the query returns the proper dates...?

am I using the improper syntax to filter my records?

HELP

JDA
 
G

Guest

Are you trying to AND the criteria, or OR them? If the
criteria are on the same line in the grid, both criteria
must be satisfied; if they are on separate lines, either
criterion will fetch a record satisfying that criterion.
If this is not the problem, post back with desired and
actual results.
 
Top