merge two fields

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

Guest

I have Feilds that are coming from a a table into a report (F1,F2,F3,F4). How
can I merge them to make one feild with a Comma seperating them. Thanks
 
In your query, you can create a new column like:
AllFields: [F1] & "," & [F2] & "," & [F3] & "," & [F4]
or set a control source of a text box in your report to
=[F1] & "," & [F2] & "," & [F3] & "," & [F4]
 
Thanks, well Done

Duane Hookom said:
In your query, you can create a new column like:
AllFields: [F1] & "," & [F2] & "," & [F3] & "," & [F4]
or set a control source of a text box in your report to
=[F1] & "," & [F2] & "," & [F3] & "," & [F4]

--
Duane Hookom
MS Access MVP
--

Max said:
I have Feilds that are coming from a a table into a report (F1,F2,F3,F4).
How
can I merge them to make one feild with a Comma seperating them. Thanks
Click to expand...
Click to expand...
 
Back
Top