Multiple Filters

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

Guest

I am trying to filter a query with multiple filters. The
first is by a field and the second is a date range. I
have the date range figured out and pretty sure I have
the field filter figured out. The only thing I am unsure
about is how to combine them.

For Example:

From [TableName]
Where (Field1 = name) and (date range)

Obviously there is a lot more stuff involved, but that is
essentially it. I guess I don't understand why this
isn't working. It isn't even doing the filter by field.
Any help please.

Thanks
 
You have the right concept; make sure your syntax is
correct. First, I assume for your date range you have a
Start date and an End Date; so then you should write your
WHERE clause as:

Where ([Field1]='Name') And ([Date] Between [Start Date]
And [End Date])
 
Back
Top