Multiple Records in Tables

[Tim]

I have four tables that each contain a unique account number for a customer
and a service rendered. I want to be able to query out the various
combinations of who had what done.

Example one table has an account # and tire rotation. The next table has
account # and oil change. The next tune-up and the next air filter.

I would like to query who had just a tire rotation, who had a tire rotation
and oil change, who had a oil change and air filter and so forth.

Any help is greatly appreciated and thank you in advance.

Tim

 

[Eighte]

What would you do? Same. It goes to Ungratefuls.

Please don`t say to us!
MoneiTakuya.

 

[KARL DEWEY]

Do not use separate tables but just add a field identifying maintenance action.
AccountID -
Customer - Text
SvcType - Text - Oil Add, Oil Change, Tire Rotate, Fix Flat, Tire Balance,
etc.
SvcDate DateTime

 

[Tim]

Got it figured out once I put everything in one table. Thanks for the help.