Between DateSerial(Year(Date()),Month(Date())-1,1) And DateSerial(Year(Date()),Month(Date()),0)

I am using the above to select the preceding 12 months data, but it does not show the current months details, can this be adapted to do this!

How about >DateAdd("m",-12,Date())?

or perhaps

Between Now()-365 and Now()

Col

Between DateSerial(Year(Date())-1,Month(Date()),Day(Date())) And Now()

[This message has been edited by Ken Grubb (edited 03-20-2002).]