fsupport1600
MIS
I am trying to create a report using the report wizard in Access 2007 and recive a message, "Could Not Create Report".
I have the following Tables:
tblProducts
productTagID
productType
ProductManufacture
ProductModel
tblRooms
RoomNumber
RoomName
tblFunitureSelection
RoomNumber (relationship)
productTagID (relationship)
Quantity
I am trying to create the following reports:
1. Report sorted by the productTagID and list the following information for that productTagID.
ProductTagID
Room Name / Numbers / Quantity
Room Name / Numbers / Quantity
Room Name / Numbers / Quantity
Sum of The ProductID:
I am unable to acheive this report using the Report Wizard. If their is another way either using a query that would be helpful.
I have the following Tables:
tblProducts
productTagID
productType
ProductManufacture
ProductModel
tblRooms
RoomNumber
RoomName
tblFunitureSelection
RoomNumber (relationship)
productTagID (relationship)
Quantity
I am trying to create the following reports:
1. Report sorted by the productTagID and list the following information for that productTagID.
ProductTagID
Room Name / Numbers / Quantity
Room Name / Numbers / Quantity
Room Name / Numbers / Quantity
Sum of The ProductID:
I am unable to acheive this report using the Report Wizard. If their is another way either using a query that would be helpful.