Access Calulations

[fsupport1600]

I have created 3 tables:

Table1: Room Information
- RoomName
- RoomNumber

Table2: Product Information
- ProductName
- ProductMake
- ProductModel

Table3: Quanity information
- RoomNumber (Relationship)
- ProductName (Relationship)
- Quantity

The user opens Table 3 and selects the room number, the product for that room and inputs the quantity.

I need to run the following reports:

Report 1:
a report for each room, the products for that room and the quantity.

Report 2:
a report for each product and the total number. The total number is based on the quantity used in each room.

Any help is appreciated.

 

[SkipVought]

Report 1:
a report for each room, the products for that room and the quantity.
[tt]
Select ProductName, RoomNumber, Sum(Quantity)
From [Quanity information]
Group by ProductName, RoomNumber
[tt]
Report 2:
a report for each product and the total number. The total number is based on the quantity used in each room.
[tt]
Select ProductName, Sum(Quantity)
From [Quanity information]
Group by ProductName
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}