With a database with customer address information in one table and phone
numbers in another table to allow for a variable number of phone numbers for
each customer, is there an easy way to export information into an Excel
spreadsheet so that there is only one line per customer, with phone numbers
in columns at the end of each line?

Thanks for any help you can provide.

"jdowding" <(E-Mail Removed)> schrieb im Newsbeitrag
news:FCE09E3D-8BF5-475E-8119-(E-Mail Removed)...
> With a database with customer address information in one table and phone
> numbers in another table to allow for a variable number of phone numbers
> for
> each customer, is there an easy way to export information into an Excel
> spreadsheet so that there is only one line per customer, with phone
> numbers
> in columns at the end of each line?
>
> Thanks for any help you can provide.

PERHAPS, you can use a crosstab query to export the data. It depends on how
your data is set up.

Customers Table

CustomerPhones Table
CustomerID
PhoneType: Fax, Mobile, etc
PhoneNumber

If your design restricts the customer to having a maximum of one of each type
of phone, then a crosstab query should be perfectly feasible for exporting the
data. If a customer could have two or more Mobile phones, then the problem is
more complex and I don't see an easy solution.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

jdowding wrote:
> With a database with customer address information in one table and phone
> numbers in another table to allow for a variable number of phone numbers for
> each customer, is there an easy way to export information into an Excel
> spreadsheet so that there is only one line per customer, with phone numbers
> in columns at the end of each line?
>
> Thanks for any help you can provide.