Query Help

[Printsol]

hi, I am newbew i need help
I have a data table and need a query to output like below table

thanks

 

[arnelgp]

use crosstab query.

 

[arnelgp]

see the Query1 and the Report.

 

[Printsol]

use crosstab query.

sorry my data table is like this, please need an assistant

 

[arnelgp]

can you put it in excel file so it is easy to manipulate.
i cannot work on an image.

 

[Printsol]

can you put it in excel file so it is easy to manipulate.
i cannot work on an image.

ok

 

[Printsol]

ok

there should be duplicate data for the same person on the same date, I want a minimum value of time for "in" status and maximum value for "out" status, Thanks

 

[Printsol]

here is excel file

 

[arnelgp]

see Query2 and report rptTimeSheet2

 

[Printsol]

see Query2 and report rptTimeSheet2

Thank You So much, I will try to understand it and let you know, Thanks a lot