On Tue, 10 Jun 2008 07:46:43 -0700 (PDT), Propoflady <ch****@monticule.com>
wrote:
>My contacts can have as many as five or six phone numbers - is it
possible to make a query that puts the name, and each phone number
after it on the same line - for this reason I have two tables - client
and phone linked by client id
right now I get
contact a - phone number 1
contact a - phone number 2
I would like
contact a - phone number1, phone number 2
Put a txt box in your report. Set the width of the box to the maximum your
report can use. Delete the label that goes with the box.
For the control source of the txt box use:
=[contact a] & " - " & iif([phone number 1] is not null, ", " &[phone number
1], "") & iif([phone number 2] is not null, ", " &[phone number 2], "") &
iif([phone number 3] is not null, ", " &[phone number 3], "") & iif([phone
number 4] is not null, ", " &[phone number 4], "")
etc, etc, etc
Just be sure there is sufficient horizontal space in your report. This will
not move any other controls to the right of the phone numbers. If you set the
width of the txt box to something less than what is needed for all the numbers
and allow the box to grow, you will be right back to where you are now, which
you don't want.
As you can see. Many ways to skin a cat. And they will all get you to where
you want to be.
Chuck
--