I'm using a database as a basis for a report in Access2003 and it's going well. I have all the correct information in it, a total for each month and a grand total at the very end of the report.
Now I wish to refine the report.
I want the FOB field to only put certain values in the report (FOB contains order data and I want only orders with a batch code including IT to show up on the report).
What can I do to make this happen? I am a relative newbie to access (just did my first small scale database project last week) and I know it's possible, but I'm not too good with Access at the moment. What am I missing? I have not been able to successfully make a query or anything else. A point to a step-by-steo tutorial would be helpful, as Access has very little in helpful help files. Thanks!
You'll want to change the properties for the report itself. You'll need to right click on the upper left corner of the report (see attached). Once there, click on the Data tab and either modify the Record Source query, or apply a filter to limit the data selected.