need query to produce multiple name badges

[Guest]

I need to create 5 or more name badges for an agency that registers 5 or more
people to attend a conference. The name badges will bear the agency name and
the agency will then assign the badges to the people it chooses to send to
the conference. I need the query to support a name badge report that prints
the # of badges according to the # in the group. Hope someone can help.

 

[Chris B via AccessMonster.com]

After you have created your databse to capture all the info, go to Reports -
New - Lable Wizard and follow the wizard, let me know if this helps....

 

[Duane Hookom]

Are you storing the number in your table? How about providing us with a
table structure of relevant fields.

 

[John Vinson]

I need to create 5 or more name badges for an agency that registers 5 or more
people to attend a conference. The name badges will bear the agency name and
the agency will then assign the badges to the people it chooses to send to
the conference. I need the query to support a name badge report that prints
the # of badges according to the # in the group. Hope someone can help.

One handy way to print an arbitrary number of replicates is to add an
auxiliary table, Num, with one field N; fill it (use Excel for
convenience) with numbers from 0 to the maximum number you'll ever
need (be generous, I use 0 to 10000).

Base your label report on a Query. Include Num in the query *with no
join line*. On the criteria line under N put

<= [tablename].[LabelCount]

using the fieldname of the field containing the desired number, or to
prompt the user just put

<= [How many labels?]


John W. Vinson[MVP]

 

[Guest]

I have tired a process similar to John's suggestion. When there is no join
line, the query seems to fail. It no longer shows any data, not just an
empty row, no row at all. I'll try again.
--
nhb -- nc

I need to create 5 or more name badges for an agency that registers 5 or more
people to attend a conference. The name badges will bear the agency name and
the agency will then assign the badges to the people it chooses to send to
the conference. I need the query to support a name badge report that prints
the # of badges according to the # in the group. Hope someone can help.

One handy way to print an arbitrary number of replicates is to add an
auxiliary table, Num, with one field N; fill it (use Excel for
convenience) with numbers from 0 to the maximum number you'll ever
need (be generous, I use 0 to 10000).

Base your label report on a Query. Include Num in the query *with no
join line*. On the criteria line under N put

<= [tablename].[LabelCount]

using the fieldname of the field containing the desired number, or to
prompt the user just put

<= [How many labels?]


John W. Vinson[MVP]

 

[John Vinson]

I have tired a process similar to John's suggestion. When there is no join
line, the query seems to fail. It no longer shows any data, not just an
empty row, no row at all. I'll try again.

That will happen if you DO have a join. If you see this happening
again, please open the query in SQL view and post it here.

John W. Vinson[MVP]