From access to sql query

I followed your instructions and still didn't work.

Regarding Access Query I have an issue in which I need help. Actually the issue is, I need to create a query to categorize every 30 mins. Would it be possible to use format([time], "mm")? PLEASE share your suggestions or solutions immediately.