Date expression to show all records from 01/01/2006 and today

[Guest]

I'm trying to enter a date criteria in my Access 2000 query to return all
records that show a date between 01/01/2006 and today. The dates entered in
the database are always the last day of any one month, i.e. 31 Jan, 28 Feb,
31 Mar, etc.
What expression do I need to enter to solve this? I'm thinking something
along the lines of:
Between 01/01/2006 and Date()

(you will probably guess that I have limited Access/query writing knowledge?!)

 

[Allen Browne]

Try what you suggested.

 

[Guest]

I don't know what I did the first time round, but I have just tried it again
and it seems to have worked
(I think I need a holiday - I'm going mad?!)

Thanks