How do I arrange my data column?

[janue]

hi, I have a table that looks like this:

And I wan to query my data that looks like this so that I can display the start time and the end time of each distinct date and in every user:

How can I do lidat? I appreciate anyone who is able to help me, and this is an access database

 

[Jon K]

Try this Totals Query, replacing with the correct table name:-

SELECT [UserName], DateValue([TableName].[Date_Clocked]) AS [Date_Clocked],
Min(TimeValue([TableName].[Date_Clocked])) AS [StartTime],
Max(TimeValue([TableName].[Date_Clocked])) AS [EndTime]
FROM [TableName]
GROUP BY [UserName], DateValue([Date_Clocked])

.

 

[janue]

thank you so much! Just exactly what I need! I slip off the Group By keywords, and im not pretty good with using SQL