ONE record per client

G

Guest

I have multiple records per client in my table and would like to reduce it to
ONE record per client. However, I would like to capture information from
each of the records.

For example:

Client No. | Account No | Deposit Amount
------------------------------------------------
123 300 50
123 520 750

Required Result:

Client No. | Account No_a | Deposit Amount_a | Account No_b | Deposit
Amount_b
-----------------------------------------------------------------------------------------------
123 300 50 520
750

Can this be done?? Thanks in advance.

Dina
 
A

AccessVandal via AccessMonster.com

Hi Dina,

What you're looking for is a spread sheet in Excel not a DataBase.
Try a repost or search on how to export records to Excel.
 
G

Guest

Thank you for your suggestion. Will do!

AccessVandal via AccessMonster.com said:
Hi Dina,

What you're looking for is a spread sheet in Excel not a DataBase.
Try a repost or search on how to export records to Excel.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ONE Record per Client 4
Appending or Concatenating rows by Client 2
How can SUM a column based on values of other columns? 6
Populate Deposit Record from another worksheet 4
Two tables / one to many relationship - need single record 1
Selecting first date of many per client 3
Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted 2
How to create a "point in time" calculation that is date stamped 1

Top