Combining records with same identifier

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that may contain one to several different records using the
same identifier/key. How do I combine them into one record? For example:

FROM-------
PIN Data1 Data2
1234 8:00 11:30
1234 12:30 15:00
4567 7:00 15:00

TO---------
PIN Field1 Field2 Field3 Field4
1234 8:00 11:30 12:30 15:00
4567 7:00 15:00

Any assistance will be greatly appreciated!!
 
I have a table that may contain one to several different records using the
same identifier/key. How do I combine them into one record? For example:

FROM-------
PIN Data1 Data2
1234 8:00 11:30
1234 12:30 15:00
4567 7:00 15:00

TO---------
PIN Field1 Field2 Field3 Field4
1234 8:00 11:30 12:30 15:00
4567 7:00 15:00

Any assistance will be greatly appreciated!!
Click to expand...

A Query must be "homogenous" - all the records must have the same
"shape", i.e. the same number of fields with each field having its own
datatype. Your desired output has an arbitrary and uncontrollable
number of fields - I don't think even a Crosstab query will work in
this case!

Could you step back a bit and explain what this data means and what
you're trying to accomplish? What will this output be used for?

John W. Vinson[MVP]
 
This data is tracking employees as they login/logout for the day. We are
trying to compare their lunch duration. Therefore, in my example for
pin#=1234, I would need to compare 11:30 to 12:30 to ensure that it was no
more than 1hr. I have tried to modify the data in excel before bringing it
into Access, but no luck. I would think that a loop comparing the pin# and
pulling out the data until it got to another pin# would work, but again, I
don't know where to start.
--AGB
 
Back
Top