|Figure 1 (above): A simplified example of a Many to Many Relationship from an Order Management Database.|
|Figure 2: A sample Invoice Report taken from one of my Order Management Database designs. |
The Order Items Section is located in the middle of the report. CostPerUnit is
displayed here as Unit Cost and Amount as Total. This section contains
details of each individual order item which, taken together,
makes up the whole order.
|Figure 3: Query with Calculated Field on the right.|
|Figure 4: The Query Output.|