Multiple record combination

  • Thread starter Thread starter Shauna
  • Start date Start date
S

Shauna

I a 192,000 record database of transactions. Each
transaction is a record, and often each customer has many
many transactions. How can I combine these transactions
so that each customer has one record with a record of each
transaction?
 
I a 192,000 record database of transactions. Each
transaction is a record, and often each customer has many
many transactions. How can I combine these transactions
so that each customer has one record with a record of each
transaction?
Click to expand...

Could you explain further? It sounds like you have a good transaction
table already, in which each transaction is - appropriately - in its
own record. Jamming multiple transactions into a single record is NOT
a good idea!

Do you have a table of Customers, related one to many to this
transaction table? Do you just want to see a report of each customer's
transactions, or what?
 
Back
Top