Access 2010 report

[artefact]

Hello,


I'd like to work out a report based on 2 tables.
The goal is to link the table of ordered qties and delivered qties according to FK of ordered qties table and the delivery dates (delivered qties table).

Table of orders



Table of deliveries



Report



The report will link the table. One important thing, I have to update the right value on the FK field in the table of deliveries.

Is it possible to do that via access 2010?

Thanks!



Arte

[ranman256]

yes, make a query by joining the 2 tables, tDeliveries, & torders
Try summing things 1 table at a time in these queries:
qsDeliverySum = select [PK], [designation], Sum([Qtys]) from tDeliveries
qsOrderSum = select [FK], [designation], Sum([Qtys]) from tOrders

then join the 2 queries together on keys
select [designation], [SumOfQtys], [SumDeliveries] from qsDeliverySum, qsOrderSum inner join [qsDeliveries].[FK] = [qsOrders ].[PK]