Time format in Query not updating to hh:nn Short Time
in [Queries]
|
Prev: How can I avoid a cartesian result?
Next: Copying records from one (sub)form to another subform using Append
From: Miki on 9 Feb 2010 22:01 Hi, I run a query, including (in design view) right clicking and clicking properties and setting format as (tried both indivifually) hh:nn and Short time. However the query still gives time to me in AM/PM format, is there a way to write it into the SQL code, or am I doing something wrong? e.g. I want 14:20 not 2:20pm cheers Miki
From: Jerry Whittle on 10 Feb 2010 09:18
Time24: Format([TheTimeField], "hh:mm") Put something like the above in the field of a query. Make sure to change the field name. Also change the "Time24" to what you want the column's header to say. It can't be the same as a field name though. On problem is that the Format function returns a string and not an actual time. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Miki" wrote: > Hi, > I run a query, including (in design view) right clicking and clicking > properties and setting format as (tried both indivifually) hh:nn and Short > time. > However the query still gives time to me in AM/PM format, > is there a way to write it into the SQL code, or am I doing something wrong? > e.g. I want 14:20 not 2:20pm > > cheers > Miki > |