Real Easy.......

[anthony.carter]

Hi,

I know the answer to this problem must be really easy because
everything I've consulted on it has seen fit to ignore it - it's so
simple.....!

I have been trying to enter a criteria to look up records that have
been entered within the last twelve months and those that were
entered over twelve months ago. I played around with <>+ AND OR () and
Now 'til I forgot my own name - all without success.

There must be an easy way to do it without having to alter the fixed
date in the criteria every day - isn't there?

Cheers,

TC

 

[Carl Rapson]

Have you tried this:

SELECT * FROM

WHERE [Date Entered] >= DateAdd("yyyy",-1,Date())

and

SELECT * FROM

WHERE [Date Entered] < DateAdd("yyyy",01,Date())

Carl Rapson

 

[anthony.carter]

Hi,

No......but I will now!

Thanks very much.

Regards,

TC

 

[Carl Rapson]

BTW, that second line should be:

SELECT * FROM

WHERE [Date Entered] < DateAdd("yyyy",-1,Date())

Carl Rapson