create name badges for a group based on the # in the group

[Guest]

In my conference registration database, there is a group registration option.
An agency can register 5 or more people. I want to print name badges to
send to the agency and permit them to identify the person for each badge.
Having the badge from the agency will be the ticket to gain admission to the
conference for each person. If one agency registers 5 people, I want the
badge report to print 5 badges with the agency name on all 5 badges. Since
there an agency could register any number of people, I would like to have the
query ask what the name of the agency is and then ask how many badges and
then produce the correct number of badges. Can someone help me design the
query correctly?

 

[Allen Browne]

Presumably you have a table that contains entries like:
Agency xyz 6
pqr 12

If so, this article explains how to print out that many labels:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

 

[Guest]

Thanks Allen. This sounds like a good solution -- I'll try it.

 

[Guest]

I appreciated you clear instructions but obviously did something wrong. I'm
hoping you will help me clarify. I looked at your website and was very
impressed -- especially with your statement about sharing your knowledge --
that's wonderful!!

First, I made the tblCount as you instructed. When I added the table to the
guery without any join, it caused the query to fail.

More about my database:

The tblGroupRegistration includes a field for the agency name and number
fields for the count of registrations ([regbothdayscount], [regfrionlycount]
and [regsatonlycount]). In my query, if I use the agency name and any one of
the registration count fields it produces the list of agencies and the # or
registrants for that option. If I add the tblCount.CountID into the grid,
the query fails. If I remove the count of regisrations field and use it in
the criteria row, the query still fails.

What am I doing wrong?

Many thanks for your help.

 

[Guest]

Do you mind if I email you directly?

 

[Allen Browne]

Make sure there is no line joining the 2 tables in the upper pane of the
query design window.

When you add tblCount to your working query, in what sense does it fail?
Error message? No records?

If it still doesn't work, switch the query to SQL View (View menu), copy the
SQL statement, and post it here.

Please don't send the database. We are not able to open and reverse-engineer
everyone's database for free.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I appreciated you clear instructions but obviously did something wrong.
I'm
hoping you will help me clarify. I looked at your website and was very
impressed -- especially with your statement about sharing your
knowledge --
that's wonderful!!

First, I made the tblCount as you instructed. When I added the table to
the
guery without any join, it caused the query to fail.

More about my database:

The tblGroupRegistration includes a field for the agency name and number
fields for the count of registrations ([regbothdayscount],
[regfrionlycount]
and [regsatonlycount]). In my query, if I use the agency name and any one
of
the registration count fields it produces the list of agencies and the #
or
registrants for that option. If I add the tblCount.CountID into the grid,
the query fails. If I remove the count of regisrations field and use it
in
the criteria row, the query still fails.

What am I doing wrong?

Many thanks for your help.
--
nhb -- nc

Presumably you have a table that contains entries like:
Agency xyz 6
pqr 12

If so, this article explains how to print out that many labels:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html