Re: need query to produce multiple name badges
- From: John Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 27 Jul 2005 10:15:31 -0600
On Wed, 27 Jul 2005 05:04:04 -0700, "Nancy"
<Nancy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>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]
.
- Follow-Ups:
- Re: need query to produce multiple name badges
- From: Nancy
- Re: need query to produce multiple name badges
- References:
- need query to produce multiple name badges
- From: Nancy
- need query to produce multiple name badges
- Prev by Date: Query Not Behaving as expected - It's asking for a parameter Access Built SQL posted.
- Next by Date: Re: Tools for record locking
- Previous by thread: Re: need query to produce multiple name badges
- Next by thread: Re: need query to produce multiple name badges
- Index(es):
Relevant Pages
|
