Query Options

  • Thread starter Thread starter Sondra
  • Start date Start date
S

Sondra

I have a database that requires approximately 50 different
reports. The only difference in the reports is a yes/no
field in the table:

Table:

Doc#
DocID
BinderA
BinderB
BinderC

Report for BinderA = yes
Report for BinderB = yes
Report for BinderC = yes

I know that I can write query for each separate
BinderReport; and I know I can write one query that can be
used for all binders by asking the user to identify the
binder they want.

But since not all the users are going to call the binder
by the same name, is there a way to use a dropdown option
for the user to choose the binder they want their report
for?

Thanks in advance.
 
You should not use field names that are binder names. Consider normalizing
your table structure so that if Doc# "123" is located in BinderB, it creates
a record in a related table like
tblDocBinders
===============
DocNumber
BinderNumber
This allows for easy querying. Plus if you need to add a new Binder, you
don't have to add a field and modify forms and reports and queries.

If you are unable to normalize your tables, consider creating a union query
that performs the same basic function.
 
Use a subform bound to tblDocBinders on a main form bound to tblDocument.
This is very much like Orders and OrderDetails.
 
Back
Top