Time Query

[Tanya via AccessMonster.com]

Hi,

i have a query that has a field formated as TStart: Format([APMTSTART],"Short
Time")

what i need to do is take 15 mins of this time but i cant seem to get it to
work the field just shows error...

any ideas greatfully appreciated.

thanks

Tanya

 

[Jeff Boyce]

Tanya

".. take 15 mins off this time..." "...can't seem to get it {?what?} to
work" "... just shows error" (?what error? what does it say?)

Is your query based on a table? What field is this particular query field
based on? What is the data type of the underlying table field?
Formatting/display is not the same as the way the data is actually stored.

Are you using the DateAdd() function to try to subtract 15 minutes? See
Access HELP re: DateAdd().

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/