Formatting Dates in a Table

[Squashed Tom]

I wish to format dates in a table before I export them into Publisher.

They currently state - HH:MM:SS PM and I wish to change to
HH: MM

I've tried replace, but it gives a "cannot find the data you're looking for
message.
Any ideas??
Thanks

 

[Joan Wild]

You don't really want to change the format in your tables.

Instead create a query based on your table and export the query. You can use the following in a column of your query to get the format you want.
Format([OrderDate],"hh:nn")

Look up Format in help - you use nn for minutes; mm is for months.