Cannot get a query in Access to output data in Time Format

[BMurf]

I have my query running, but my problem lies in the format that the answer is outputed. The inputs are all in short time format, after the formula is ran through the query it is outputed in decimal format. Can someone help me ?

 

[elizabeth]

Is the input field filled manually or by using the date or now function? If by function, Date is better if you want date only, Now stores as Date & Time no matter how you format the input field. <br><br>BTW, there is a separate Access forum on this site if you have other Access questions.

 

[IG]

Hi,
have you tried formatting the fields in the SQL Select clause, like -

SELECT Format(

.[Field],&quot;h:nn am/pm&quot as FieldName
FROM Table
WHERE...

give it a try.