Access 2010 combining tables into 1 for exporting

I have multiple tables with a Customer in common.  I would like to combine the different tables into a Main table, with Customer data all on the same line.

DAILY PAYMENTS
Customer
PaymentReceivedDate
Payment Amount Date

DAILY BILLING
Customer
Billing Address
Shipping Address

DAILY ORDERS
Customer
ProductNumber
OrderDate
ShippingDate
ReceivedDate
NNiicckkAsked:
Who is Participating?
 
GozrehConnect With a Mentor Commented:
Do you have in all tables all customer you want to export ?

Why not create query
SELECT [DAILY BILLING].Customer, [DAILY PAYMENTS].PaymentReceivedDate, [DAILY PAYMENTS].[Payment Amount Date], [DAILY BILLING].[Billing Address], [DAILY BILLING].[Shipping Address], [DAILY ORDERS].ProductNumber, [DAILY ORDERS].OrderDate, [DAILY ORDERS].ShippingDate, [DAILY ORDERS].ReceivedDate
FROM [DAILY PAYMENTS] INNER JOIN ([DAILY BILLING] INNER JOIN [DAILY ORDERS] ON [DAILY BILLING].Customer = [DAILY ORDERS].Customer) ON [DAILY PAYMENTS].Customer = [DAILY ORDERS].Customer;

Open in new window

then export it.
0
 
NNiicckkAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.