merge two fields

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
 
D

Duane Hookom

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]
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding fields 6
How do I create a report based off of several Combo Box selections 4
IIF QUERY 2
please help on this one... 4
Feeding Worksheet Data Into a Query 6
Excel Excel Tab between Controls NOT Keydown > Activate (Worksheet) 0
Crosstab query 1
Most efficent way to produce new table from 2 tables 2

Top