Displaying transaction time punch data in a time card form

• trevor.feller

  Valued Member

  Points: 56

  More actions

  October 7, 2015 at 4:30 pm

  #321802

  Hello,

  I have a table called employee_punch_record that we use to store employee time clock punches.

  The columns are:

  employeeid,

  punch_timestamp,

  punch_type (In / Out),

  closed (bit used as status for open or closed pay periods),

  ident

  Here are some examples of a record:

  bkingery62015-10-06 16:59:04.000In0

  bkingery72015-10-06 16:59:09.000Out0

  bkingery82015-10-06 16:59:13.000In0

  bkingery92015-10-06 18:22:44.000Out0

  bkingery102015-10-06 18:22:46.000In0

  bkingery112015-10-06 18:22:48.000Out0

  bkingery122015-10-06 18:22:51.000In0

  tfeller52015-10-05 17:00:05.000In0

  We are using SQL Server 2008 as our database and use Access as a GUI. I am looking to create a form in Access where employees can access their time card and request changes from management. I want to use the format from the attached screen shot for the form. I pretty much know how to do it all, the only point of complication is trying to figure out the easiest way to get the transaction punch record data on employee_punch_record into a format where I can easily populate the form in the horizontal format you see in the screen shot.

  I am not super strong in SQL, but figure I can do it using a formatting table of some sort. Does anyone have a quick and easy way to move transaction records into a more horizontally oriented record?

  Thanks a ton in advance!