Merge records with same number

D

Dale Laurich

I have a table that has a primary key (ID number), and an account Num
and a time/date field. I would like to merge the time/date field of
all of the entries with the same accnt Num
ie.
Original
ID AcctNum Date/Time
1 12345 01/01/2012 1500
2 12345 02/03/2012 0400
3 12345 04/18/2012 0315
4 66542 01/11/2012 0100
5 66542 01/28/2012 0812

New
AcctNum(PK) D/T1 D/
T2 D/T3
12345 01/01/2012 1500 02/03/2012
0400 04/18/2012 0315
66542 01/11/2012 0100 01/28/2012 0812



I need to determine time intervals between the date time fields

Thanks in advance for any guidance you could provide.
 

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

Find then highlight in yellow 6
How do I count the number of blank cells 0
Reverse Index Match 2
Check if a date comes before/after a range of dates 0
Calculating occupational sick pay entitlement 0
Please help for FV and XIRR function. 3
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Word crashes doing mail merge 0

Top