I have a large number of people who have multiple capacities in multiple years. For example: Donor, Host, Driver, etc. For a Donor, I need to keep up with the Year and the Amount of the donation for that year. Similar problems with other groups. What would be the best way to accomplish this? Make groups such as "Donor 2015", "Donor 2014" etc? Or is there a better way just to create a group "Donor" with something like sub-groups for each year attached to the amount? If this is covered somewhere, please point me in that direction. I can sometimes make the shift from order tracking to people management, but not always!!
Reply from Alex Hedley:
I'd add another Field of Year and record that too, it would then give you the option to query on both criteria.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 7.