Combine same records into 1

[nyrob609]

Hi All,

I need some assistance I have a large table with (159,000) records must records are have the same demographic data by account and date of service except there are two columns that have different values.

Is there a formula or way in access where I could combine the same records into 1 and put the different values of the other records at the end or the record. (ok I got confuse explaining it)

for example

LNAME, FNAME, Account#, DATE, Charge, Code
LNAME, FNAME, Account#, DATE, Charge, Code
LNAME, FNAME, Account#, DATE, Charge, Code

I want

LNAME, FNAME, Account#, DATE, Charge, Code, charge, code, charge, code

I need to send the data out and the person requesting wants everything on one line not multiples records

Any assistance will be greatly appreciated.

Thank you all

 

[DJkarl]

Well let me say whoever is requesting the output like that is an idiot.

But I cannot think of an easy way, I think some custom VBA code might be needed, opening up a sorted recordset and looping through it building your output file might be the way to go.