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
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