Problem deleting records based on month (1 Viewer)

matt2006

New member
Local time
Today, 03:09
Joined
Nov 20, 2006
Messages
9
Hi Ive got a lot of help from this forum by just browsing through

But I'm at a dead end (I'm still kind of a newbie)

I want to write an sql or vba code to delete records based on the month:
For example I have a field called date which contains a date and I want to delete all Dates that are In April

Ive tried
Delete from LinkTable Where month(Date) = 'April'
Still Nothing

If anyone can put me out of my misery It would be appreciated

Thanks Matt
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 03:09
Joined
Aug 30, 2003
Messages
36,118
If you look in help, you'll see the Month() function returns a numeric value. ;)
 

matt2006

New member
Local time
Today, 03:09
Joined
Nov 20, 2006
Messages
9
If you look in help, you'll see the Month() function returns a numeric value. ;)

thanks pbaldy, I overlooked that, its been driving me crazy so I missed the obvious :banghead:
 

Users who are viewing this thread

Top Bottom