Inclusive dates criteria in a query 1

[robojeff]

I have a query which uses an end date from a form to determine the range of the data that I wish to extract from MY_tbl in which I would like to gather 12 months of data up until the end date.

I need some help with the criteria of this query as it gives me 12 months of data but leaves off the month (or partial month) of data for the month of the End date...

How can I tweak the following criteria to capture the portion of the current month (the form's end date month) and still include that month from the previous year?

Here is the criteria portion of my SQL:

 WHERE (([My_tbl].Date) Between DateAdd("yyyy",-1,[Forms]![My_rpt]![EndDate]) And [Forms]![My_rpt]![EndDate])

thank you

 

[PHV]

WHERE My_tbl.Date Between DateSerial(Year([Forms]![My_rpt]![EndDate])-1,Month([Forms]![My_rpt]![EndDate]),1) And DateSerial(Year([Forms]![My_rpt]![EndDate]),Month([Forms]![My_rpt]![EndDate])+1,0)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[robojeff]

That works great... thank you!