extracting day from date

[Ben Joseph]

I have in my database a field called Hire Date. How do I run a query to
select all those with dates that are the first of any month of any year?

 

[XPS350]

I have in my database a field called Hire Date. How do I run a query to
select all those with dates that are the first of any month of any year?

.... WHERE Day([Hire Date])=1


Groeten,

Peter
http://access.xps350.com