Mail merge not showing all

[Noel]

I have a mail merge that is not showing all of the members. I have a member
that has more than 1 record. The mail merge recipient list is only pulling up
the first record and doesn't show the second record. Do I need to certain
criteria in one of the query fields? If so, what would that be?

Thanks

 

[Jeff Boyce]

Noel

Please post the SQL statement of your query. Open the query in design view,
select the SQL view, copy the SQL and paste it into your response.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Noel]

SELECT tblMember.SSN, Format(tblMember.[Member ID],"0000-0000") AS MemberID,
Format(tblMember!SSN,"000-00-0000") AS SSNF, tblMember.FirstName,
tblMember.LastName, tblMember.Street, tblMember.City, tblMember.State,
tblMember.ZipCode, tblMember.[Date of Birth], tblServicePurchase.SPID,
tblServicePurchase.[Date Received At IPERS], tblServicePurchase.[Today's
Date], tblServicePurchase.SSN, tblServicePurchase.[Highest Wage],
tblServicePurchase.[Highest 3 Average], tblServicePurchase.RegularYOS,
tblServicePurchase.[Current Occupation Code],
tblServicePurchase.TypeofPurchase, tblServicePurchase.Investment,
tblServicePurchase.[Qtrs to Purchase], tblServicePurchase.Quarterly_Cost,
tblServicePurchase.Total_Cost, tblServicePurchase.NumberofRegularCredits,
tblServicePurchase.BuyUpTotalQuarters, tblServicePurchase.BuyUpQuarterlyCost,
tblServicePurchase.BuyUpTotalCost, tblServicePurchase.[Due Date],
tblServicePurchase.[Cost Letter Created],
tblServicePurchase.QuarterlySubsidy, tblServicePurchase.TotalCostWithSubsidy,
tblServicePurchase.Specialist_ID, tblMember.BuyBackCreditQuarters,
tblServicePurchase.Comments
FROM tblMember INNER JOIN tblServicePurchase ON tblMember.SSN =
tblServicePurchase.SSN
WHERE (((tblServicePurchase.TypeofPurchase) Is Not Null) AND
((tblServicePurchase.[Qtrs to Purchase]) Is Not Null) AND
((tblServicePurchase.Quarterly_Cost) Is Not Null) AND
((tblServicePurchase.Total_Cost) Is Not Null) AND
((tblServicePurchase.NumberofRegularCredits) Is Not Null) AND
((tblServicePurchase.BuyUpTotalQuarters) Is Not Null) AND
((tblServicePurchase.BuyUpQuarterlyCost) Is Not Null) AND
((tblServicePurchase.BuyUpTotalCost) Is Not Null) AND
((tblServicePurchase.[Due Date]) Is Not Null) AND ((tblServicePurchase.[Cost
Letter Created]) Is Null));

 

[Noel]

I got the information to pull into the query. But if a member has two
records, it is pulling them into two different lines. I need it to be
included in one line so that way when they information is pulled it is merged
into one letter for the member instead of two.

 

[Jeff Boyce]

Another way to approach this is to allow your letter to have more than one
line for members ...

Regards

Jeff Boyce
Microsoft Office/Access MVP