All data until start of current month

[ryangus]

I'm looking to create a query that shows all data within a table up
until the end of the previous month. e.g. for this month (March
2007), I want to see all data up to and including February 2007.

Can anyone asist?

 

[Allen Browne]

Criteria of:
< (Date() - Day(Date()) + 1)

 

[ryangus]

Many thanks