Query to display dates for specific months

F

Faio

Can anyone help me.

I have a table which contains a field called StartDate and contains all
date in the form of dd/mm/yy.

I wish to create a query to display only entrie for January, how do I do
this?

Thanks for any help
 
N

Nikos Yannacopoulos

Erika,

In your query design, add a calculated field as follows:

Expr1: Month([StartDate])

and in the first criteria row behind it type 1

HTH,
Nikos
 
Top