Skip to Content
0
Former Member
Sep 08, 2009 at 11:07 AM

Query - weight delivered each day

15 Views

Hi all.

I'm currently working at a query to calculate the weight delivered each day. My thougt is to first calculate from DLN1 table and then subtract from RDN1 table. Deliveries minus returns.

I can easily create these queries as stand alone queries, but I would need some help combining them into one query. I'm thinking coulmns like this; A = date, B = weight deliveries, C = weight returns, D = B minus C

Any takers?

Thanks and regards.

Runar Wigestrand.