I have this table:

Original table
Key ID T Date In Time In Date Out Time Out
-----------------------------------------------------
8 110 I 12/3/2010 7:36 - -
9 110 O - - 12/3/2010 11:50
10 110 I 12/3/2010 12:57 - -
11 110 O - - 12/3/2010 16:31

Same table consolidated
Key ID T Date In Time In Date Out Time Out
-----------------------------------------------------
8 110 C 12/3/2010 7:36 12/3/2010 11:50
10 110 C 12/3/2010 12:57 12/3/2010 16:31

- = null

How can I do this with a button on a form in Access?
In a software I have (made maybe in Fox Pro) they have a menu option to do this. I want to do this too but in access.

Yap

It can't easily be done without coding it. I would imagine you could use code to generate IDs by replacing say the Key 9 with 8 and from that query, join that query to your table using this code generated ID. Then pull the fields from there.