Merging multiple fields on one row into a single field in a 2nd ta

G

Guest

I am trying to merge the contents of multiple fields on one (record) row, as
per the
example below, where i want the data from Run_Point_Venue_X and
Run_Point_Address_X to populate just two fields in a new table.

The two new field names will be: Run_Point_Venue_All and Run_Point_Address_All

Example Fields:

Run_point_List_ID Run_No
Run_point_Venue_A Run_point_Address_A
Run_point_Venue_BRun_point_Address_B Run_point_Venue_C
Run_point_Address_C Run_point_Venue_D Run_point_Address_D

To put another way, I were using Excel as an example, I want to take pairs
of cell contents from multiple rows and place them all in just two columns.

I have tried using multiple queries via a macro, but the macro just loops
endlessly, generating duplicates of the fields.
 
M

Michel Walsh

Hi,


Maybe the formatting didn't kick in, but it is far from being crystal clear.
Can you give another example of what you start with, and the result you want
form it, or/and rephrase the process?


Vanderghast, Access MVP
 

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

Merging multiple fields on one row into a single field in a 2nd ta 8
Union fields in the order they appear in the table 17
How do I express more than 2 SELECT FIELDS within the same table? 3
returning multiple records on a single line 3
Concatenating multiple values into a single field on a report 5
Sum of multiple fields into single field from subqueries 5
Merge a field data for all records in a table into one output 2
multiple fields from a combo box in a single field in related tabl 2

Top