Need to return "yes" or "no" for times later than

[rbpercussion]

The title explains it. I have a table with start times, and I want to build a query where the results of the field return yes or no depending on whether or not the time was later than 8am. I need this to be done with field functions only(i.e.with the builder), no sql, or any formatting to circumvent anything. Please and thank you so much.

[ranman256]

in the query:

YesNo: IIF(format([field],"hh:nn ampm")>#08:00 am#,"yes","no")

[rbpercussion]

Where do I put that expression, in the field name or in the criteria of the "starttime" field

[JoeM]

See here for instructions on how to add calculated fields to a query: http://www.fontstuff.com/access/acctut02.htm