Formatting time: eliminate additional :00

I would like to include a time and date together (not the current one, but
from the database).

When I use:
=([Date]) & ", " & ([Time])

I get:
4/30/2009, 9:15:00 AM

How can I get rid of the last :00?

=Format([Date] + [Time], "m/d/yyyy \, h:nn")

Incidentally, if those are your real field names, change them. Date and TIme
are both reserved words, and should never be used for your own purposes. For
a comprehensive list of names to avoid (as well as a link to a free utility
to check your application for compliance), check what Allen Browne has at
http://www.allenbrowne.com/Ap****ueBadWord.html

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Claudia in DC" wrote in message
...
I would like to include a time and date together (not the current one, but
from the database).

When I use:
=([Date]) & ", " & ([Time])

I get:
4/30/2009, 9:15:00 AM

How can I get rid of the last :00?