query between two dates 1

[slybitz]

I have a table that has a three dates columns: one for the day, one for the month, and one for the year. I'm trying to pull data from this table in a query but between two certain dates (4/1/2004 and 3/1/2004). How can I go about doing this?

Thanks!

 

[slybitz]

I'm sorry correction: there are only two fields: month and year. There is no day field.

 

[PHV]

A starting point:
WHERE DateSerial([Year field],[Month field],1) Between #2004-03-01# And #2004-04-01#

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[slybitz]

PHV - Thank you so much. Worked perfectly!