HELP - time display format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kwizzy - 31 Jan 2007 16:17 GMT

I am trying to make a report design easier by concatenating 2 dates separated
by a hyphen rather than having 3 separate controls, but I cannot get the
times to display as hh:mm rather than hh:mm:ss even tho' singly they are
perfect. If there is a way to set up the expression with the specific format
in the underlying query I can't find that either. It's driving me insane!!!!

Reply to this Message

Allen Browne - 31 Jan 2007 16:21 GMT

I think you are trying do put something like this in the Control Source of
your text box:
=Format([Date1], "mm\/dd\/yyyy h\:nn ampm") & " - " &
Format([Date2], "mm\/dd\/yyyy h\:nn ampm")

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I am trying to make a report design easier by concatenating 2 dates
>separated
[quoted text clipped - 4 lines]
> in the underlying query I can't find that either. It's driving me
> insane!!!!

Reply to this Message