Real Easy.......

A

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
 
C

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
 
C

Carl Rapson

BTW, that second line should be:

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

Carl Rapson
 
Top