Question Creating Mail Merge

[Snuffy94]

I have a DB that I use to track my churches contributions. In the past, I've created the mail merge letter that grabs the total donation for each member. They now want the donation by member for each week. For each donation made by a user, a unique id is created. What I not been able to figure out is how to grab the next unique donation id for a user so that it shows their donation for the next week.

 

[GinaWhipp]

Hmm, take a look at Albert's Super Easy Mail Merge...
http://www.kallal.ca/msaccess/msaccess.html

 

[Snuffy94]

Gina,
I'm able to setup the mail merge. Let me see if I can explain it better. In my mail merge document, I have a table that I want to populate with the donation date and the donation amount. I'm able to grab the first record for the first member. So for week #1 for member #1, I can find the donation date and donation amount. The donation table is in sequential order, so the next record would be for another member. I need to find the next record for member #1 for week #2 and have it populated into the next cell in the table and repeat it for all of the weeks in the year.

 

[GinaWhipp]

Oh, yep I get it better now...

Yep, that leaves me out, never tried that with Word.

 

[Snuffy94]

Thanks for the input...

 

[GinaWhipp]

I found this!

http://www.devhut.net/2012/04/23/ms-access-vba-export-records-to-ms-word/

 

[Snuffy94]

Hey Gina,
The code in the link doesn't do what I need... Thanks for the help...

Charles

 

[GinaWhipp]

Sorry, that's all I can think of...

 

[Gasman]

Wouldn't that just be presenting the data to the mailmerge in a different order.?

member id
Date of donation ascending
Amount

Gina,
I'm able to setup the mail merge. Let me see if I can explain it better. In my mail merge document, I have a table that I want to populate with the donation date and the donation amount. I'm able to grab the first record for the first member. So for week #1 for member #1, I can find the donation date and donation amount. The donation table is in sequential order, so the next record would be for another member. I need to find the next record for member #1 for week #2 and have it populated into the next cell in the table and repeat it for all of the weeks in the year.