Parameter box to print one lable for two people at same address

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

garyf - 30 Mar 2006 22:57 GMT

I'm trying to print one label for two people at the same address following
the sample given at
http://support.microsoft.com/default.aspx?scid=kb;en-us;207753&Product=ass
for ACC2000.

When I run "qryMailingList" a parameter box appears. If I click on it
without inserting anything, the Name2 field is blank. If I put a name in it,
then Name2 is that name for everybody. The field is as follows: Name2:
IIf(qryLabelNames1.ListName=qryLableNames2.ListName,"
",qryLableNames2.ListName)
Any suggestions?

Reply to this Message

[MVP] S.Clark - 03 Apr 2006 19:57 GMT

The import part is the name of the parameter in the prompt.

Is that name part of your query or table?

Signature

Steve Clark, Access MVP
http://www.fmsinc.com/consulting
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

> I'm trying to print one label for two people at the same address following
> the sample given at
[quoted text clipped - 5 lines]
> it,
> then Name2 is that name for everybody. The field is as follows: Name2:

IIf(qryLabelNames1.ListName=qryLableNames2.ListName,"",qryLableNames2.ListName)

> Any suggestions?

Reply to this Message

garyf - 04 Apr 2006 02:25 GMT

I finally determined the problem. I had incorrectly spelled one of the
queries. It now works. Your answer is right on, I just didn't catch the
error for a long time. Thanks for your response.

> The import part is the name of the parameter in the prompt.
>
[quoted text clipped - 12 lines]
> IIf(qryLabelNames1.ListName=qryLableNames2.ListName,"",qryLableNames2.ListName)
> > Any suggestions?

Reply to this Message