Import records from last month

[martinainscough]

I have a table accessable by ODBC and am trying to create a query to only import the records for the previous month. I am struggling on the criteria for the query.

If anyone could help me it would be much appreciated

Thanks

Martin

 

[RichO]

Add an expression field to the query: =Month(MyDateField)

And as the criteria for that field: Month(DateAdd("m", -1, Date()))

 

[martinainscough]

Thanks, that worked great!

Martin