Prev: SQL Select Query Prompting for NonExistent Parameter
Next: DateDiff
From: Ben Joseph on 18 Mar 2010 01:52
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?
From: XPS350 on 18 Mar 2010 03:10
On 18 mrt, 06:52, Ben Joseph <BenJos...(a)discussions.microsoft.com>
wrote:
> 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
 | 
Pages: 1
Prev: SQL Select Query Prompting for NonExistent Parameter
Next: DateDiff