Concatentation of Recordset?

[Debra Farnham]

Hi All

Access 2K Win 2K

I apologize for the long post however here goes:

Using the following query, I am able to obtain the results listed (way)
below. What I need to do is drop the information into a string variable so
that it appears as follows:

6/22/2005 - John Smith
Bob Doe

9/22/2005 - Jane Doe
Jim Smith


The above information will eventually appear as details of a reminder in
Outlook (I am already familiar with creating the reminder, I'm just not
certain how to concatenate the data so I can get it there).

I will also have to capture the date in a variable as it will be the date
used to set the reminder.

SELECT [strFirstName] & " " & [strLastName] AS FullName,
IIf([LessThan2080]="",[MoreThan2080],[LessThan2080]) AS
BenefitsMustBeCancelledBy
FROM qryCancelBenefits
ORDER BY IIf([LessThan2080]="",[MoreThan2080],[LessThan2080]),
qryCancelBenefits.autActualSeniority;


Returns:

FullName BenefitsMustBeCancelledBy

John Smith 6/22/2005
Bob Doe 6/22/2005
Jane Doe 9/22/2005
Jim Smith 9/22/2005

TIA for any assistance. Please let me know if I have not explained my
problem in a satisfactory manner.

Debra

 

[Debra Farnham]

This post can be ignored

I'm 99% of the way to figuring it out. What I was attempting to do in this
post was not going to produce the outcome I desired.

Thanks for reading anyway.

Debra