Access DB Question

[stargal98]

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

[TheBearMay]

Should be able to Right-Click on the upper left corner of the form and select Properties for the report. Then either modify the Record Source query, or apply a filter to limit the data selected.

[stargal98]

So I will have to make a form in order for it to work?

[TheBearMay]

My bad, still a report, just need to edit the properties.

[stargal98]

Okay, so which properties would I change and where are they located? I tried changing the control source, but that didn't work...

[TheBearMay]

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.

[stargal98]

was there supposed to be something attached?

[TheBearMay]

Well there was when I hit submit... Let's try this again.

Edit: Didn't take again...fine...Try clicking here

[stargal98]

Okay, got it. Thank you!