John K
04-24-2007, 12:46 AM
Question? You are to read each data record from the Seq. Access file and calculate/determine:
?The selling price of the item? The last 2 characters of the Part# is the markup rate used to calculate the selling price
?The extended worth (cost * qty on hand (alpha!)) of each item.
?The storage location of the item, embedded within the Part #, chars. 4 & 5:
CodeOutput Value
oW1 = Warehouse #1
oW2 = Warehouse #2
oSR = SalesRoom
oSS = Salesroom Storage
?At report?s end report:
oAverage cost of all items
oTotal Worth of all items, Complete total of all inventory?
Round appropriately!
With appropriate statements, design a report including:
On each page, show:
Title line1 with your name, Company name, and Page Number
Title line 2 with current system date
2 line columnar headings? i.e. PartItemItem
Number DescriptionCostetc.
?The selling price of the item? The last 2 characters of the Part# is the markup rate used to calculate the selling price
?The extended worth (cost * qty on hand (alpha!)) of each item.
?The storage location of the item, embedded within the Part #, chars. 4 & 5:
CodeOutput Value
oW1 = Warehouse #1
oW2 = Warehouse #2
oSR = SalesRoom
oSS = Salesroom Storage
?At report?s end report:
oAverage cost of all items
oTotal Worth of all items, Complete total of all inventory?
Round appropriately!
With appropriate statements, design a report including:
On each page, show:
Title line1 with your name, Company name, and Page Number
Title line 2 with current system date
2 line columnar headings? i.e. PartItemItem
Number DescriptionCostetc.