MAILING LABEL GROUPS

[Guest]

I have a database of customers for which I want to print address labels
depending on what group I have entered them in. There are about 30 different
groups that they could be a member of. I have entered them in to groups by
using "yes/no" fields on the customer table to indicate who is a member of
which set. My problem is that I know how to indentify which group is
required using sql

eg select surname,address from table where GP

where GP is one of the possible groups. I cannot however see a way of
selecting the group variable from a form and entering into a query, so that I
can print the required label set.

Can anyone please advise me on this or point point me in the direction of
an example. Many thanks in advance.

Regards

Peter

 

[Rick B]

Not sure how easy that will be since you do not have a normalized design.
You made the mistake of storing data (the group name) in a field name.
Instead, you should of had a field called "Group" and then select tthe group
from a drop-down list. If people can be members of more than one group,
then you should of had three tables where one stores people, one stores
valid groups, and one stores an entry for each person/group combination.

If you had normalized, then you could simply add a drop-down field to your
parameter form where the user could select a valid group from a list.