Table, Query, Report

[finlain]

I created my table importing external data. I created a query to get my data only. I created a report and manipulated it to get to look the way I want.
Now when I run the report it always pulls in all the records in mthe table. I want to run the report for just February data now, but it gives me all records from January 1, 2010 through now. i know I have done this before many times but I have tried several options.
I created a filter to get just the records I want in the report etc etc.


I know I am misssing something very simple here

[smyers]

I'm not an acess expert, but I would create a query with a condtion (date range or month) off of a form with a report preview button (this will allow you to run anytime with different variables), set your record source of your report to the new query with the form criteria.

[Access_Blaster]

You could use a parameter query. Open a new query pull in all the relevant fields. If you have a field that holds dates put this in the criteria.

 
[Enter a date] or Like [Enter a date] & "*"