Reporting filter criteria
Posted on 2003-12-09
I've created a database that uses a form filter as the basis for presenting forms and reporting of records. The filter fields as chosen on the form are saved as a query for appliction to the forms and reports. The fields chosen to act as filters (as well as the data chosen to act as the filter - e.g. a person's initials) needs to be reported on a report. There are about a dozen fields that can be used as the basis for the filter though normally only 1-2 will be used. I therefore need a way of reporting only the query fields that are active as filter criteria.
I hope that is clear and that someone can help!