I sincerely hope this is an easy one, but I can't seem to figure it out!
I've created my table. A very straightforward database. The ONLY reports I need to generate on a regular basis from this table are monthly service reports. So I open the table, filter the date column for "last month" only, save the table as a copy under a different name, then generate a report using that table using the report wizard. But when the preview comes up, it still has ALL the data from the original table! Not just the month I want.
The table filters the dates perfectly, so what gives?
What am I doing wrong?!