I have a query whose date parameter comes from a form. The form has an 'end date' control to run a trailing twelve month report. I want the query to pull data between the end date on the form and twelve months prior. My criteria is below, the first part with the "-12" is not working. I don't want to use a start date on the form to get around this. Please advise. Thanks!
Between [Forms]![frmMarginBucketReportFilter]![EndDate]-12 And [Forms]![frmMarginBucketReportFilter]![EndDate]