Can't keep dates filtered on my reports!

[Mr. Coffee]

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?!

[William McKinley]

I would create a query based on the original table containing all of your data, set criteria parameters within that query (say for a beginning and ending date range), then build your report based off that query. When you run the report it would prompt you for the query's selection criteria.

[Mr. Coffee]

when you say 'query', do you mean report? Or is a 'query' something different? I've only just began using Access so I'm not entirely familiar with it.
Thanks

[William McKinley]

Queries are mechanisms used to find data within your tables, amoungst a wide range of other functions.

Here's a link to some MS Office knowledge on queries:
http://office.microsoft.com/en-us/ac...010341786.aspx

[Mr. Coffee]

Queries are mechanisms used to find data within your tables, amoungst a wide range of other functions.

Here's a link to some MS Office knowledge on queries:
http://office.microsoft.com/en-us/ac...010341786.aspx

Alright. Found the query function, constructed a new query table filtered the date column, THEN generated the report... and it did the same thing. Brought up ALL my entries from when I started in September. Not just the ones I wanted from November.

[William McKinley]

Try using a parameter query then linking it to your report. Once set up, the user will be prompted for search criteria every time you open the report. Refer to this article for an indepth look: http://office.microsoft.com/en-us/ac...010096314.aspx