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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?!)
 
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
 
Back
Top