I have a table feeding a query feeding a form. The dbf is to collect improvement suggestions on a network from users.
Suggestions can either be from an individual user or from a group of users.
points are allocated to the individual (1) on entry. then if accepted, an extra 4 points is awarded and the best of the month an extra 25. No problem in reporting this data.
The problems begin when the user wants to enter a group suggestion.
On clicking yes on a field, 6 fields (GM1, GM2,..) appear for the user to select the group members. Also 6 fields for the point allocation appear (GM1p,GM2p,..).
So the problem is this...
I need to be able to create a report that will show a summary per user of his/her points.
This has to be based on when the user is a proposer(individual) and any time the user is in any one of the GM fields.
This is driving me mad....can anyone please help...no matter how small or large the advice, it will be all very much appreciated.
Thanks very much
Suggestions can either be from an individual user or from a group of users.
points are allocated to the individual (1) on entry. then if accepted, an extra 4 points is awarded and the best of the month an extra 25. No problem in reporting this data.
The problems begin when the user wants to enter a group suggestion.
On clicking yes on a field, 6 fields (GM1, GM2,..) appear for the user to select the group members. Also 6 fields for the point allocation appear (GM1p,GM2p,..).
So the problem is this...
I need to be able to create a report that will show a summary per user of his/her points.
This has to be based on when the user is a proposer(individual) and any time the user is in any one of the GM fields.
This is driving me mad....can anyone please help...no matter how small or large the advice, it will be all very much appreciated.
Thanks very much
