Filtering A Report

[Cinnamon]

My Dad's company had someone in anohter office creat an Access database, but some of the functions didn't work, so my Dad asked me to fix it.

One of the problems is that they have a report that they want to be able to filter by date. I got it to filter but then got input boxes asking me for the parameters of some of the fileds, like "Job Costs". They were working all right before so my filter screwed it up.

So I was wanting to know what is the best way to go about filtering a report by date?

Thanks
Cinnamon

 

[stormin_norm]

I doubt it was the filter which messed up the report.
Take a look some of the fields you messed with. Did you change the record source in any fields?
Perhaps from "JobCosts" to "Job Costs"? Maybe you put an extra space in?

Perhaps you changed the underlying query to the report. Or calculated field which was "Job Costs: xyz * abc" now became [Job Costs] and you are being prompted for this.

 

[Cinnamon]

See that is just it, and why this is so confusing. All I did was go into the properties of the report and make sure the filter option was ON and then entered the name of the filter I did not touch anything else When I was done and ran the report it did filter it like I had intended but then I got all these boxes asking for the parameter of all these other fields SO I thought I would see how other people filtered their reports*.

 

[stormin_norm]

You should check the underlying query to the report. It sounds like it has parameters which need to be defined. They are probably set by a form.
Look at the criteria section of the query. If you don't know which query. Click on the upper left corner of the report. Turn on or make sure the properties are visible. And you should see the query name. Then go to the queries open it in design mode. Look at the criteria section.

 

[WayneRyan]

Cinnamon,

Your report is probably based on a query. The query probably
used some value(s) from a form as criteria, or as a filter.

If the form was not OPEN, then Access will ask you to provide
the values.

If that is not it, can you dummy up some data, compact your
db, ZIP it and post it here?

Wayne