Formatting Dates in a Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Squashed Tom - 24 Jul 2007 14:22 GMT

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

Signature

Thanks
Squashed Tom

Reply to this Message

Joan Wild - 24 Jul 2007 14:28 GMT

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.

Signature

Joan Wild
Microsoft Access MVP

>I wish to format dates in a table before I export them into Publisher.
>
[quoted text clipped - 5 lines]
> Any ideas??
> Thanks

Reply to this Message

Joseph Meehan - 24 Jul 2007 17:59 GMT

> I wish to format dates in a table before I export them into Publisher.
>
[quoted text clipped - 5 lines]
> 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.

Signature

Joseph Meehan

Dia 's Muire duit

Reply to this Message