Query Help

L

lmossolle

Is there a way to set a defalt to pick up the last 13 months?
I am using a between date range and would like to have a code to avoid
changing the dates...
If so please assist...
 
F

fredg

Is there a way to set a defalt to pick up the last 13 months?
I am using a between date range and would like to have a code to avoid
changing the dates...
If so please assist...
Click to expand...

Between Date() and DateAdd("m",-13,Date())

will return records between 4/26/2006 and 3/26/2005

Is that what you want?
 
Top