information from two tables

[Guest]

Hi, I have two tables one shows our UPS billings and another for our freight
billings. I need to have a query by job number that shows all our billings on
a certain date. My issue is that you may have just a freight billing, just
UPS billing or both. None of the joins right, left, or inner pick up all the
information I need.

Example of tables

Freight UPS

date billed date billed
job number job number
billed amount billed amount

Help if you can!

Thanks
Jeanne

 

[Guest]

Maybe you could have just one table with 4 columns:

billing type
date billed
job number
billed amount

 

[Guest]

Or you could try using a union query.

-----Original Message-----
Maybe you could have just one table with 4 columns:

billing type
date billed
job number
billed amount

shows
all our billings on
.

 

[Guest]

Yes, I did this using Union All I found on another question.
The tables feed a lot of other information so I could not put them into one
table.

Thanks for you help