Combobox on a report?

[NewShoes]

Hey all,

I'm not that used to reports in Acces. I was just wondering if it's possible to have a combo box actually on the report, perhaps in the header? This would be used to filter the report for sprecific customers.

Also, out of interest, is it possible to SUM and COUNT etc in a report? or would this be done in the query behind that he report?

Thanks,
-NS

 

[plog]

An access report is used to produce a hard copy of your data, so no you cannot include a combo box or anything interactive on it. You can however include a form that has a drop down that allows a user to use criteria that is then passed on to the report to produce just the data you want on it.

You can have Count and Sum totals in a report. You would need to create a grouping level and then place the Count and Sum data in the group header or footer. For example if you were creating an employee directory for your entire company you could group employees by department and have a department footer that totals how many people are in that department, their cumulative years at the company and even average age. Then the report would continue on with data for the next department.

 

[PaulWilson]

I've seen a number of posts about using where conditions and filters to filter reports prior to their being opened. What about filtering an OPEN report.

I use Access 2007 and on my reports, I can right-click in a field and filter the open report contents any number of ways. You can also use the funnel icon to filter open reports. It's too bad you can't put a combo box up there in the report header so you can "save" a filter as a "view" much like the way Excel lets you save filtered views for later use.

I guess you could put a hyperlink on the report which pops up a form containing a combo box which encapsulates the filtering you want. The on-change event for the combobox would close and re-open the report with filtered contents using the standard where condition or filtering.

Any other ideas?