Two rows into one

[RICK]

I have a very large access database (about 150,000 records). Several of the
columns contain identical information (both text and numbers). I need to
group some of the "nearly identical" records into one record with the single
differing column showing the information in each record separated by columns.
I have tried the generic concatenate sample at
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'
However, this is not working for me as I do not have the capability to set a
single unique column nor are the columns that I am working with that have
identical values numeric columns. The generic concatenat apparently only
works with numeric columns.

I have tried to create a unique numeric column using a concatenation of
several of the text columns and then updating the information into a separate
column. That is "update table set combinecolumn = 1 where concatenatedcolmn
= '134153A6908Y'. However, I have several thousand of these update
statements to run and apparently Access queries can only handle one update
statement at a time.

Any help would be appreciated.

RICK

 

[Duane Hookom]

The generic concatenate function does work with numeric, text, or even date
fields. All you need to do is create the appropriate sql statement to send
to the function. Since you haven't provided any information about tables,
fields,... we can't provide much additional assistance.