MS Access help

[Tsuyoiko]

Sorry my thread title isn't very specific.

 

I'm working on a table in Access, here's an extract:

 

 

I want to eliminate duplicates in the Module_Code field, and merge the data in the UserText1 field, so I end up with something like this:

 

 

Any suggestions on a query or series of queries that could do this would be much appreciated.

 

Thanks in anticipation.

[truedeity]

pk= primary key, fk=foreign key.

 

best approach is to use a cross reference table.

 

tblModuleCodes

---------------

ID, *pk, Autonumber.

ModuleCodeName, text.

 

tblModuleCodeItems

--------------------

ID *pk, Autonumber.

ModuleCodeItemName, text.

 

 

tblCrossRefModCodes

--------------------

ID *pk Autonumber

ModuleCodeID, numeric, *FK

ModuleCodeItemsID, numeric, *FK.

 

 

then simply write a sql, use the cross reference table to query/populate/append to, a table that you need.

 

also, more scaleable, and saves space...

[Tsuyoiko]

Thanks for your reply. In the end I did it by defining a Concatenate function in VB. The code is here:

http://tek-tips.com/faqs.cfm?fid=4233