Time Format Problem in Query (1 Viewer)

Hi,

I have a problem with a time field in my db.

I have a field that captures start and finish times.

When I use the data through a query and into a word doc the time format shows as:

09:30:00AM

instead of

09:30 AM

If I run the query from the qbe, the output shows:

09:30 AM

So the output in the qbe is correct. Why does it change from the query window to the word doc and how do I rectify it?

Thanks in advance

Darrell....

format ([fieldname], "hh:mm")

Thanks, that works fine.

Darrell...

I'm glad to hear that you solved your problem.