how to get the desired report output

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

Guest

Hi Everyone, I have a table that look similar to this:

Employee Dte IN OUT
Jane Doe 2/21/2005 10:00 10:30
Jane Doe 2/21/2005 12:00 13:00
Jane Doe 2/21/2005 16:00 18:00
Jane Doe 2/22/2005 8:00 10:00
Jane Doe 2/22/2005 13:00 17:00
Jane Doe 2/23/2005 8:00 15:00

How can I make it so that the report output will look like this for each
employee:

Jane Doe's Report

Dates 1st Shift 2nd Shift 3rd Shift
2/21/2005 10:00 10:30 12:00 13:00 16:00 18:00
2/22/2005 8:00 10:00 13:00 17:00
2/23/2005 8:00 15:00

Thanks so much,
 
Arlene. The easiest way I can think of is that you add a sequence number to
your first table, than you can create a crosstab query to do exactly what you
expressed.
Hope this helps.
Fons
 
Thanks for replying, sorry for the delayed comeback (my bad, I almost forgot
about this), actually I thought about adding a sequence number, I just dont
know how to do it automatically. How do you create a sequence number ?

Thanks again.
 
Back
Top