I want to query data based on a form. The form has a single date field named txtEndDate.
But in the query criteria I have:
Between [Forms]![frmDate]![txtEndDate]-365 And [Forms]![frmDate]![txtEndDate]
which I'm sure isn't the right way to do it especially if it was a leap year. I want to end up querying from a year ago through the date entered on the form.
How should my criteria read?