Tsuyoiko Posted May 11, 2009 Share Posted May 11, 2009 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. Link to comment Share on other sites More sharing options...
truedeity Posted May 21, 2009 Share Posted May 21, 2009 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... 1 Link to comment Share on other sites More sharing options...
Tsuyoiko Posted May 21, 2009 Author Share Posted May 21, 2009 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now