How to create a telephone list with both customers and suppliers

[Grd]

Hi there,

When I try and do this I get the phone numbers side by side and each
customer next to each supplier. So its a complete mess.

Is it possible to create a list of both customer and supplier telephone
numbers in one query, not having to do to.

Any help would be greatly appreciated

tx

Suzanne

 

[John Spencer]

What is the structure of your table (or tables)?
It sounds as if you have at least four fields in one record - customer,
CustomerPhone, Supplier, and SupplierPhone.

Is that correct? Or if not, what is the structure of the table(s).

IF you have two queries to get the information, you could probably use a
UNION query to join the two into one query and use that.



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[Grd]

Thanks John,

I tried the UNION you suggested by copying and pasting two separte queries,
one for the suppliers and a seperate one for the cutomers with UNION in
between. I did this in the SQL view and it works perfectly.

Tx for the suggestion

S