Hello
Need advice on how to tackle the following :
This is the table structure that I use:
Item Detail Table
=============
Itemid
Item No
Item Description
Unit
Unit Price
Sub Code information Table
=====================
subcodeid
Sub code no
Sub code Description
Tender Quantity
Itemid
Item Payment Table
==============
Paymentid
Date
Payment Quantity
Reference
Remarks
Subitemid
What I need to do produce a new report every month. Having the following Headings:
Item No.
Item Descriptions
Unit
Tender Quantity
Previously Quantity
Previously Paid Quantity
Quantity this Period
Unit price
Payment This Payment
Item No—to be group (100 to 199) (200 to 299) etc so there is a report per group with headings above
and all items must be listed even if it doesn’t have payment -- How do I do this??
Previously Quantity & Previously Paid Quantity – How do I get all previously Quantity summed?
Payment This period = unit price * Quantity this period
Any advice would be great. I'm fairly new at access
Alfred67
Need advice on how to tackle the following :
This is the table structure that I use:
Item Detail Table
=============
Itemid
Item No
Item Description
Unit
Unit Price
Sub Code information Table
=====================
subcodeid
Sub code no
Sub code Description
Tender Quantity
Itemid
Item Payment Table
==============
Paymentid
Date
Payment Quantity
Reference
Remarks
Subitemid
What I need to do produce a new report every month. Having the following Headings:
Item No.
Item Descriptions
Unit
Tender Quantity
Previously Quantity
Previously Paid Quantity
Quantity this Period
Unit price
Payment This Payment
Item No—to be group (100 to 199) (200 to 299) etc so there is a report per group with headings above
and all items must be listed even if it doesn’t have payment -- How do I do this??
Previously Quantity & Previously Paid Quantity – How do I get all previously Quantity summed?
Payment This period = unit price * Quantity this period
Any advice would be great. I'm fairly new at access
Alfred67
