concatenating table field in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report in which I need to have the the services for the listed
account(s) in one field. I was provided the function from The Access Web for
concatenating the info into one field. The query and report are completed
with the exception of the one field. And this is where I am not that
proficient. Where do I place the function so the one report field shows the
services for each listed client? The function is typed just the way it
showed on The Access Web.
Thanks to anyone who assists.
*** John
 
My apologies as I forgot to add the query to the post. Below is the query
that is used for the report so far. The services table is called
usrtblServices2 and the field is called Service2Initial (this was a takeover
project from someone so don't bash me to bad for the nameing - it is slowly
getting redone).

SELECT usrtblClientInformation.ClientID,
usrtblClientInformation.ClientName,
usrtblClientInformation.ClientServicesPerson,
usrtblClientInformation.OverallClientStatus,
usrtblClientInformation.LostBusiness,
usrtblClientInformation.ExpirationDate,
usrtblClientInformation.LostAdminRevenue,
usrtblClientInformation.LostMCRevenue,
[LostAdminRevenue]+[LostMCRevenue] AS [Total Revenue],
usrtblClientInformation.ReasonForLeaving,
usrtblServices2.Service2Initial
FROM usrtblClientInformation
INNER JOIN usrtblServices2 ON usrtblClientInformation.ClientID =
usrtblServices2.ClientID
WHERE (((usrtblClientInformation.OverallClientStatus)="Active") AND
((usrtblClientInformation.LostBusiness)="Yes"));
 
Back
Top