Here is my dilema and hopefully someone can help this dork! 
1. I'm a retirement plan advisor for a trust fund for municipalities and created a database to track contacts with the muni's through conferences and onsite visits...So far it looks something like this.
Main tables -
tblMemberInfo (Muni name, contact person, address, etc...
tblContacts (Muni name, date visited, visit type (phone, in-person), notes, etc.....
tblEventAttendees (City name, Event Name, Attendee name).....
I created three sub tables that I use to pull info from for the Main tables using combo boxes. The sub tables are one for "City names", "Event Info", "Visit Type". I use "City Names" for both the Event Attendees and Member Info tables. A city (municipality) can attend an event but not necessarily be a member of our retirement system.
2. I created forms for the three Main tables so that I could input data as I get it...whether it's a new member, or a new conference, a new contact.
3. I generated some queries so that I can see several things... A. Members that attend conferences... Members that haven't attended conferences.... and Non-Members that attend conferences.
I accomplished this by doing some comparison queries such as - If a city attended an event but doesn't have a match on the Member Info table, they aren't a member. If a city attended an Event and they are on the "Member Info table"... and the reverse.. Listed members on the "Member table that didn't have a match on the Event Attendees table. Hope this isn't confusing so far.
Last! I just use the Contact table all by it's lonesome and made a report that groups by City (Member) name and shows who made the visit, date of visit, type of visit (in person, phone call).
Now my question, FINALLY! How can I make it so a user can generate a report for a specific City/Member contact strictly by inputing the City/Member name in an input box? And, how can I also take the Contact table and generate a report of Cities visited within a specific date range where the user only inputs the date range they want to see?
Also, how could I have done the other parts cleaner? I'm a novice but I want to learn how to be more efficient.
Sorry for the massive post... but I appreciate any help!
-Stefan
1. I'm a retirement plan advisor for a trust fund for municipalities and created a database to track contacts with the muni's through conferences and onsite visits...So far it looks something like this.
Main tables -
tblMemberInfo (Muni name, contact person, address, etc...
tblContacts (Muni name, date visited, visit type (phone, in-person), notes, etc.....
tblEventAttendees (City name, Event Name, Attendee name).....
I created three sub tables that I use to pull info from for the Main tables using combo boxes. The sub tables are one for "City names", "Event Info", "Visit Type". I use "City Names" for both the Event Attendees and Member Info tables. A city (municipality) can attend an event but not necessarily be a member of our retirement system.
2. I created forms for the three Main tables so that I could input data as I get it...whether it's a new member, or a new conference, a new contact.
3. I generated some queries so that I can see several things... A. Members that attend conferences... Members that haven't attended conferences.... and Non-Members that attend conferences.
I accomplished this by doing some comparison queries such as - If a city attended an event but doesn't have a match on the Member Info table, they aren't a member. If a city attended an Event and they are on the "Member Info table"... and the reverse.. Listed members on the "Member table that didn't have a match on the Event Attendees table. Hope this isn't confusing so far.
Last! I just use the Contact table all by it's lonesome and made a report that groups by City (Member) name and shows who made the visit, date of visit, type of visit (in person, phone call).
Now my question, FINALLY! How can I make it so a user can generate a report for a specific City/Member contact strictly by inputing the City/Member name in an input box? And, how can I also take the Contact table and generate a report of Cities visited within a specific date range where the user only inputs the date range they want to see?
Also, how could I have done the other parts cleaner? I'm a novice but I want to learn how to be more efficient.
Sorry for the massive post... but I appreciate any help!
-Stefan
Last edited:
