Is it something like this you want?
qryAnalysis
qryAnalysis
Group | NumberOfEvents |
---|
AA | 84 |
AB | 7 |
KP | 98 |
KP - | 63 |
KP + | 35 |
If so just follow the pattern. Cut and past one of the queries and change the criteria and the group name. Then open the union query in and you will have to do some more cut and paste.
Thanks for getting back me, yes that's it sort of. It seems to be a alternative way of doing it, than I have at the moment, which is cool. With the help from earlier posts, I managed to get the data by. Using multiple IIF() in a report based on query criteria of USER and SECTION number. The problem is the GROUPS (search criteria AA, AB) have to be done for each user and each section ie 3 queries (USER 1 + section1, USER1 + SEction2, USer1 + Section 3) and a report with 9 groups (search criteria) in unbounded texts with IIF() for the 700 users, which is soul destroying slow .......... so we ie me
was hoping that with the constraints of very varied data poorly constructed DB, these steps could be reduced further to something like 1 query per user which could give the 9/10 group totals for section 1,2,3 ie 30 totals.
Thanks again for for the help, I hope the above makes sense.
The eventdetail field is created by a user log, and I have no control of the data but have to extract the 9 Groups (search criteria) from very varied data.