problem with clocking in access 2007

[basante]

hello.
i have to make a clockig in access, for a finger print machine.
the problem is that i have 3 rows for one person in same day. for example :

name date in out

basante 12/12/2008 9:16 12:02
basante 12/12/2008 9:16 18:02
basante 12/12/2008 13:15 18:02

working time is betwen 9:00 and 18:00, so i want just :
basante 12/12/2008 9:16 12:02
basante 12/12/2008 13:15 18:02

thanks for you help in advance

 

[Dennisk]

You need totals query, one Column for the Min Date/Time (For that Day) and one Column for the Max Date/Time (For that Day). use a 2nd query with the Min/Max query as the recordsource and subtract Min from Max.

 

[basante]

thanks Dennisk.
i'm noob, can you explain more pls.

i dont know how to make one column with min date/time, and one column with max date /time

 

[Dennisk]

Hi,

Create a query then convert it to a totals query (on the view menu).

Each column can then have a total type - min, max, average, groupby, count, sum etc

 

[basante]

tks, i will give a try