How to present the report

O

Opening balance

Hi,
I am beginner of ACCESS. My Question is that I would like to present the
report as below:
Product# Qty at end/Month1 Add/Deduct in Month2 Qty at
end/Month2

Tables for Product is made. Query for 'Add/Deduct in Month2' is made.
'Qty at end/Month2' is accumulated. Number of products during Month2 is not
same as that under 'Qty at end/Month2'. For example, there are two products
made but there are 10 products in the list at end/Month2.

It seems this is accounting entries but how I can prepare them in ACCESS
which automatically generete the report.

Thanks and regards,
Roy
 
Top