fraser_lindsay
Access wannabe
- Local time
- Today, 05:54
- Joined
- Sep 7, 2005
- Messages
- 218
Hello,
I have two tables main tables in a one to many relationship. Main table is 'tool info', primary key is tool serial. Each tool can have many records assigned it containing 'test data' in a seperate table.
I have set up a QBF to allow me to produce a report based on parameters such as tool type, tool condition, department etc and the associated data. At the moment all my report can do is print each test record for each tool basde on the QBF.
I would like to be able to report a specific tool using my QBF but have the report display statistics based on however many records assigned to that tool type and condition e.g. mean, max and min. In effect producing a list of tools (based on the QBF) and summary information.
I have tried searching the forum for similar threads but not really found a particularly helpful one yet.
Does anybody have any suggestions?
I have two tables main tables in a one to many relationship. Main table is 'tool info', primary key is tool serial. Each tool can have many records assigned it containing 'test data' in a seperate table.
I have set up a QBF to allow me to produce a report based on parameters such as tool type, tool condition, department etc and the associated data. At the moment all my report can do is print each test record for each tool basde on the QBF.
I would like to be able to report a specific tool using my QBF but have the report display statistics based on however many records assigned to that tool type and condition e.g. mean, max and min. In effect producing a list of tools (based on the QBF) and summary information.
I have tried searching the forum for similar threads but not really found a particularly helpful one yet.
Does anybody have any suggestions?
