jetersauce
Registered User.
- Local time
- Today, 10:19
- Joined
- Dec 21, 2010
- Messages
- 20
I have a report that needs to take all of the values from a field concatenate them into a line and remove the duplicates. I have tried some VBA concat modules but haven't been successful in finding a solution.
I need this:
OrderID
1030
1031
1049
1053
1053
1054
1054
1054
1059
1059
1060
1060
To show on the report as:
Order IDs: 1030, 1031, 1049, 1053, 1054, 1059, 1060
Any ideas on how to do this?
(I originally posted this in the Reports forum but I think the VBA forum is more appropriate)
I need this:
OrderID
1030
1031
1049
1053
1053
1054
1054
1054
1059
1059
1060
1060
To show on the report as:
Order IDs: 1030, 1031, 1049, 1053, 1054, 1059, 1060
Any ideas on how to do this?
(I originally posted this in the Reports forum but I think the VBA forum is more appropriate)