rell
Industrial
- Aug 9, 2002
- 3
Hi, One for all you pro's out there! Try to get your heads round this one, The tables are:
Table 1 = Item
ItemCode (primary key)
Description
Format
Unit price
Stock Level
------------------
Table 4 = CustOrderItem
CustomerOrderNo (pk)(fk)
ItemCode(pk)(fk)
CustOrderQuantity
CustOrderUnitPrice
Comments
DateActioned
The query needed is to provide a list of ItemCode, Description, number and value of customer (number means the number of Customer Orders placed for the Item, 'value' is the total value of Customer Orders placed for the Item) placed for that ItemCode during the current month (the month when the query is actually run), and display details in order of ItemCode within descending average value (average is the average value of Customer Orders placed for the Item)
The Select statement must be able to be run month after month without being modified, ie it should not include embedded dates.
Go for it.......
Table 1 = Item
ItemCode (primary key)
Description
Format
Unit price
Stock Level
------------------
Table 4 = CustOrderItem
CustomerOrderNo (pk)(fk)
ItemCode(pk)(fk)
CustOrderQuantity
CustOrderUnitPrice
Comments
DateActioned
The query needed is to provide a list of ItemCode, Description, number and value of customer (number means the number of Customer Orders placed for the Item, 'value' is the total value of Customer Orders placed for the Item) placed for that ItemCode during the current month (the month when the query is actually run), and display details in order of ItemCode within descending average value (average is the average value of Customer Orders placed for the Item)
The Select statement must be able to be run month after month without being modified, ie it should not include embedded dates.
Go for it.......