Re: create name badges for a group based on the # in the group
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Mon, 25 Jul 2005 09:00:22 +0800
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.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Nancy" <Nancy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0B6B3BFF-9314-438B-86DF-6C5DF2EADE2C@xxxxxxxxxxxxxxxx
>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
>
>
> "Allen Browne" wrote:
>
>> 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
>>
>> "Nancy" <Nancy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:93D9F783-576C-4F7C-A7E2-447DFB93D8D5@xxxxxxxxxxxxxxxx
>> > 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?
>> > --
>> > nhb -- nc
.
- References:
- Prev by Date: Re: Stripping a field value
- Next by Date: Error 1013 user requested cancellation
- Previous by thread: Re: create name badges for a group based on the # in the group
- Next by thread: Re: create name badges for a group based on the # in the group
- Index(es):
Relevant Pages
|
