hambone Posted January 26, 2005 Share Posted January 26, 2005 I am trying to modify the database for a small non-profit. I am not a database guy and to date have only done simple modifications to our system. So here is what I am trying to do and how I am trying to do it. We have a members database. I want updateable list for each member record showing which activities they attended. I want to be able to search for members who attended activities based on date, number of events, sponsor of event etc. I want to be able to add new activities. I also want to do a number of calculations across this data including a count of activities each member attended, total number of members that attended more than x number of activities etc. Until now, we have stored this information in a big text box list. Searches are extremely limited. So I am looking for a way to accomplish this and thought that building a related Activities file would accomplish this. But maybe I am barking up the wrong tree and there is a better way to accomplish this Link to comment Share on other sites More sharing options...
This topic is 6624 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now