Apply filter for Printing

A

Andrew

I have 5 tables. One uses [Report No] and link to fields [ID]. [ID] is
duplicates ok and indexed, [Report No] is no duplicates and indexed. The
"child tables" use the [Report No] in the [ID] Can I write a filter that
links all the info to send to reports using anly the [Report No], [ID]...I do
have queries that send info to reports but filtering a report is based on the
[Report No] Field.
 
A

Allen Browne

See:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

Download the sample database discussed in that link. It explains how to
build a Filter string dynamically, based on a form where the user enters
their filter values in unbound controls. The example applies the filter to
the form, but it is exactly the same process for a report. In the end, you
use the filter string in OpenReport.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Seperate Tables Seperate Reports, Please make them one. 1
filtering for reports 1
Filtering subreports on main report 0
Printing a report for a single ID 1
Filtering problem 1
Filter for subreports 11
apply a filter in a report / subreport 2
Duplicate data on reports 2

Top