need some help

[moustafa]

hi every one ;
my regards for you;

i have two tables the first have these fields :
CUSTOMER_QTY
TRUCK_NO
DRIVER
TRANSPORTER
CITY
CUSTOMER_NAME
TOTAL
PRICE_TON
QUANTITY_TON
TYPE BAGS_NO
TRANSPORTER_NO
DELIVERY_DATE
DELIVERY_NO
NO

the second tables have these fields :


1. customer_name
2.the amount owned
3.monthly paid
4.pay date
remaining balance


*** the point *** i need to make a query that can give me all fields for the second table with
these fields from the First Table ( customer_name & QUANTITY_TON &DELIVERY_DATE & type & total )

 

[JHB]

What problem do you have with that?
Use the QBE-window, add both table to the query, link them together with relevant field(s), choose the the fields you want from the tables.

 

[namliam]

Please tell me you dont actually have Customer Name that is your key between those two tables???

 

[moustafa]

i al ready make the query but i have a small probleme that i need to add a new column that calculate the defference between the total column from the forst table and the all paid columen in the second table ......

** any idea **

 

[namliam]

well make a query first to SUM all the paid amounts
Then make a query to sum all the invoices
then subtract the 2 query results in a third query.

 

[moustafa]

i did the two query but how i can make the subtract query

 

[namliam]

How about doing
Sum of invoices - sum of paid amounts
?