Hi,
I am trying to enter a formula for the criteria in a query that would be between the date entered in the text box of a form & 12 months prior to that date (returning the 1st day of the month). For example, I currently have Between #1/1/2013# And #12/31/2013#, but I need it to use the text box of my form. The text box will have the end date, but I need the criteria in the query to look for records that are between 12 months prior to the date in the text box (returning the 1st day of the month) and the date in the text box.
I am hoping that I have asked the question correctly, but can someone please help?
Thanks,
Joflow21