joenudi
10-14-2004, 11:24 AM
Point of Contact | Attendee
-------------------------------------------------------------------
Doe , John ; Doe , Jane
Doe , John ; Doe , John
Doe , John ; Dye , Mike
Edy , Luke ; Edy , Luke
MS Access 2003. There are 3 tables.
The first table contains the name of every individual that is involved in the project with a random database ID number.
The second table contains the ID number of those individuals who are points of contact (this must be separate table from the first).
The third table contains the ID number of an event attendee and their point of contact (a person may be their own point of contact).
I currently have a query that gives me info as above with a point of contact and an attendee name.
The goal is to have a report that gives...
Doe, John - Point of Contact
Doe, Jane
Doe, John
Dye, Mike
Edy, Luke - Point of Contact
... etc.
I do not know a way to make the report automated (Access VB on Detail Format) without somehow joining the records for each point of contact so that the first name is the Point of Contact and any number of attendees might follow (1-20+) on a single record instead of 3 records as above.
Does anyone know of a solution by (Access) VB (some sort of do while loop on the point of contacts ID number), query (making all of the records for john doe as the point of contact into a single longer record) or by report creation techniques that would enable me to create a report as specified above.
Please feel free to ask questions as I am sure I have left something out.
Joe Nudi III
-------------------------------------------------------------------
Doe , John ; Doe , Jane
Doe , John ; Doe , John
Doe , John ; Dye , Mike
Edy , Luke ; Edy , Luke
MS Access 2003. There are 3 tables.
The first table contains the name of every individual that is involved in the project with a random database ID number.
The second table contains the ID number of those individuals who are points of contact (this must be separate table from the first).
The third table contains the ID number of an event attendee and their point of contact (a person may be their own point of contact).
I currently have a query that gives me info as above with a point of contact and an attendee name.
The goal is to have a report that gives...
Doe, John - Point of Contact
Doe, Jane
Doe, John
Dye, Mike
Edy, Luke - Point of Contact
... etc.
I do not know a way to make the report automated (Access VB on Detail Format) without somehow joining the records for each point of contact so that the first name is the Point of Contact and any number of attendees might follow (1-20+) on a single record instead of 3 records as above.
Does anyone know of a solution by (Access) VB (some sort of do while loop on the point of contacts ID number), query (making all of the records for john doe as the point of contact into a single longer record) or by report creation techniques that would enable me to create a report as specified above.
Please feel free to ask questions as I am sure I have left something out.
Joe Nudi III