Formatting Dates in a Table

[Guest]

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.

 

[Joseph Meehan]

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

To add to Joan's response remember that a Table should be considered as
nothing more than a bucket in which data is dumped for storage. It has a
label on the bucket defining the data in each field. Use forms, queries &
reports to enter, edit and display data. You will be happier in the long
run.