I could use some help on a report that is driving me nuts.
We are using Access 97 currently on a network that will have approximately 10 users.
I need a report to show all information completed in the month 6 months from the past month. My form provides a to and from date fields that are entered. I tried a hidden text box that calculates 180 days from the system date, but that provides errors as information left out and information added that is for the next month. Skewing the results of the report.
So if you enter October 1, 2003 in the "To" text box and "October 31, 2003" in the "From" text box the report should then pull all completed item six months from October, which would be everything completed in April 2003. I am using the criteria: =DateAdd("m",6,Date()) The is under the Date of Removal field.
I should receive 45 results of this, but receive 0.
Any advice or where to look for a better way would be much appreciated.
Originally posted by jmrSudbury
try -6 to go back 6 months
I tried that. my results ended up being for the month of May. Do you have any ideas on how to obtain the results for the month of April?
The supervisors will be pulling the information at the beginning of the 7th month. I replaced the 6 with a 7 but received zero results.