converting hour into number

[frustratedwithaccess]

Hello All,



In one of my access tables, I have a field "time" listing times as hour (i.e. the data entered, contains medium times such as 6:15 AM, 7:16 AM, 9:20 PM etc however I have formatted as "h" to only display the hour). In terms of the new query I need to create, I only need the hour of each time in order to group by hour. However, grouping doesn't work due to initial data being entered with minutes. How can I group specifically by hour in my new query, or how do I convert hour into a number?

Hope someone can help

Cheers!

[June7]

Format property does NOT change the raw data.

Is this a date/time data type field?

Use functions to extract date/time parts.

Year([fieldname])

Month([fieldname])

Day([fieldname])

Hour([fieldname])

[JeffChr]

... maybe "Format property does not change the raw data." ?

[ssanfu]

I have a field "time" listing times

"Time" is a reserved word in Access (along with "Date", "Month", "Year") and shouldn't be used as object names. "Time" is also a function... Using "Time" as a field name will cause you headaches.
Plus it is not very descriptive; "Time" of what? Start time, End time, Entry time,...???

In terms of the new query I need to create,......

As June said, in a empty column in the query, enter something like

TheHour: Hour([Time])

-------------------------------------------
Edit:
Here is a list of reserved words - http://www.allenbrowne.com/AppIssueBadWord.html

[June7]

... maybe "Format property does not change the raw data." ?

YEP, corrected post. Fingers and brain not coordinating.

[JeffChr]

LOL yep, sometimes mine run at different speeds also.

[frustratedwithaccess]

Thanks all!

Managed to get this sorted with suggestion of functions to extract date/time parts.