problem with multiple criteria select query...?

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

Guest

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
 
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.
 
Back
Top