An acces Query on a Date ? !Help!

Hi,

I try to make a query on a date.
I've a table with medium date: 12-Feb-04
I would like to find date with only Month and year...
What can I put in The criteria qury ?
I try with a search like Feb-04 It does'nt work... Wath is the stored format ?

Thank you for your help

Mrflo

Why not just put the first and the last of the month in the criteria to find all options in a month ?

ie. >=#01/02/04# AND <=#29/02/04#

Conver the date to month and date and seach off these new items


SELECT Table2.DDATE, Month([DDAte]) AS Month1, Year([DDate]) AS Year1
FROM Table2
WHERE (((Month([DDAte]))=4) AND ((Year([DDate]))=2004));


S-