I can't figure out how to get my multitable/multiquery query to work

[barrettw4]

I have 4 different tables for loads for different companies and one of additional payments. I am trying to create a query so i may create a report for payroll. I am using multiple tables because the info for each is very different and there are hundreds of loads a day



tblDrivers- all other tables are related - has info on drivers and pay percentages
tblWhiteLoads- loads from White... I also have a query of white loads that just provides info i would use for payroll. Driver, LoadDate, CustName, and the driver pay for the load
tblGPLoads - Loads from GP... also have query same as white
tblTank - Loads from tanks... same as above
tblAdditionalWork - extra bonuses and work besides main work to be added to payroll - Driver, Date, reason, amount

I am wanting to query so all the data comes in one report so I can sort through and create one simple printoff for payroll instead of printing 4 pages out and calculating them after. this is the only thing i lack to completing my database and it is incredibly frustrating. If there is a better way i could do this let me know. I would like the report to just have Driver, Date, Customer, Driver pay. I know that is for reports but i thought id share if it would be easier doing it another way.

HELP PLEASE AND THANK YOU!!!

[orange]

Please tell readers what a White Load is compared to a GP Load. Also you might want to give readers a 30000ft overview of your business in plain English. Once someone understands WHAT you are trying to do,there may be options as to HOW it might be achieved.
Good luck.

[barrettw4]

White and GP are the companies the loads are dispatch for. This is for a trucking company. Basically with this database, I dispatch load numbers and receive data from the load to send invoices, breakdown income for our book keeping, and do payroll. i just want to consolidate all the loads per pay period by driver then print the report, but I think I need to create a query to get all the information together.

[orange]

I suggest you work through this tutorial from Rogers Access Library. It may seem like a step back to you, but I can assure you this will benefit you. You have to work through it, but you'll learn some basic concepts on tables, design and relationships. Pay particular attention to the process involved. Also, pay attention to how the requirements are described. What you learn can be applied to any database.

Good luck.

[barrettw4]

i am still trying to figure it out. maybe something pertaining to multiple multiple one to many relationships going to the same field? not sure how to correct this...

[orange]

Did you work through the tutorial?

[barrettw4]

Yes, it was basically how I created the table. I think the problem I am having isn't clear. I need to know how to create the query so each driver has all the values for each load of all the different tables. I just need to know how to go about doing this.

[orange]

I think the problem I am having isn't clear.

I agree.
You need a clear statement of the issue/opportunity in simple English.
You can identify your tables, their attributes and relationships between tables
using pencil and paper, post-it type notes etc. Getting the tables and relationships
identified and tested is critical.

It seems you are dealing with these (generally)
Drivers
trucks
loads
dispatches
work breakdown
invoices