Populating report

[nlburgess via AccessMonster.com]

The report I am wanting to create is based on two tables. One table
"Meetings" contains all meeting information like date, location, audience,
etc. The other table "mtgAttendees" contains attendees for each meeting and
they are linked by mtgID. One meeting can have multiple attendees thus
multiple entries in "mtgAttendees" linked by mtgID. For my report I want to
each row to show the meeting information inluding all attendees for that
meeting.

ie.

mtgID Date Location Audience Attendees
1 2/22/08 Charlotte Some Dude Attendee1, attendee2, attendee
3, attendee 4

 

[Evi]

The report I am wanting to create is based on two tables. One table
"Meetings" contains all meeting information like date, location, audience,
etc. The other table "mtgAttendees" contains attendees for each meeting and
they are linked by mtgID. One meeting can have multiple attendees thus
multiple entries in "mtgAttendees" linked by mtgID. For my report I want to
each row to show the meeting information inluding all attendees for that
meeting.

ie.

mtgID Date Location Audience Attendees
1 2/22/08 Charlotte Some Dude Attendee1, attendee2, attendee
3, attendee 4

Firstly, I can see a problem with your database structure. you need at least
3 tables, not two.
1.the Attendees table
2.The Meetings Table
3.The Attendees In Meetings table.

After all, if you are lucky, your Attendees may attend more than one
meeting.

Is Audiance really just 1 item per meeting? Sounds like one of those grim
foreign films!

As to the report

For clarity's sake, wouldn't you be better off having the report grouped by
Meeting and then have a 2 /3column subreport listing the attendees under
each meeting header?

Evi

 

[nlburgess via AccessMonster.com]

Thank you for your response. I actually figured it out about 10 mins after I
posted. I used a subreport to display what I needed and everything works
great. And I only use two tables because my mtgAttendees are linked to my
contacts and meetings. It would be repetitive to list the attendees separate
in another table.

If I am wrong please explain.

The report I am wanting to create is based on two tables. One table
"Meetings" contains all meeting information like date, location, audience,

[quoted text clipped - 9 lines]

1 2/22/08 Charlotte Some Dude Attendee1, attendee2, attendee
3, attendee 4

Firstly, I can see a problem with your database structure. you need at least
3 tables, not two.
1.the Attendees table
2.The Meetings Table
3.The Attendees In Meetings table.

After all, if you are lucky, your Attendees may attend more than one
meeting.

Is Audiance really just 1 item per meeting? Sounds like one of those grim
foreign films!

As to the report

For clarity's sake, wouldn't you be better off having the report grouped by
Meeting and then have a 2 /3column subreport listing the attendees under
each meeting header?

Evi

 

[Evi]

The report I am wanting to create is based on two tables. One table
"Meetings" contains all meeting information like date, location,

audience,
[quoted text clipped - 9 lines]

1 2/22/08 Charlotte Some Dude Attendee1, attendee2, attendee
3, attendee 4

Firstly, I can see a problem with your database structure. you need at least
3 tables, not two.
1.the Attendees table
2.The Meetings Table
3.The Attendees In Meetings table.

After all, if you are lucky, your Attendees may attend more than one
meeting.

Is Audiance really just 1 item per meeting? Sounds like one of those grim
foreign films!

As to the report

For clarity's sake, wouldn't you be better off having the report grouped by
Meeting and then have a 2 /3column subreport listing the attendees under
each meeting header?

Evi

--

Thank you for your response. I actually figured it out about 10 mins after I
posted. I used a subreport to display what I needed and everything works
great. And I only use two tables because my mtgAttendees are linked to my
contacts and meetings. It would be repetitive to list the attendees separate
in another table.

If I am wrong please explain.

You say your Attendees are linked to your Contacts - you mean you have a
third table for Contacts? You said in your email that you had 2 tables in
your db, thus the misunderstanding.

Evi

 

[nlburgess via AccessMonster.com]

I was just explaining the tables I was using for the report. Glad we are on
the same page and thanks for your help.

[quoted text clipped - 23 lines]

--

Thank you for your response. I actually figured it out about 10 mins after I
posted. I used a subreport to display what I needed and everything works

[quoted text clipped - 3 lines]

If I am wrong please explain.

You say your Attendees are linked to your Contacts - you mean you have a
third table for Contacts? You said in your email that you had 2 tables in
your db, thus the misunderstanding.

Evi