Query to display dates for specific months

  • Thread starter Thread starter Faio
  • Start date Start date
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
 
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
 
jfdsj k9uek idjgl iegek aalegdjvoa
idfe9d id
can you seek book who
yong man is you
]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dlookup 7
Query DOBs for those in a specific Month 1
How to run a date based query for many months 9
Stored date is not being recognised 1
date format problems with export to csv 1
Changing the date format & adding the date range to the header 1
convert dd and mm and yy fields to one dd/mm/yy field 4
Modifying Date Range 3

Back
Top