Date format in table after a make table query

Question

Need help to set the date format in the table output from a make table query.

The date always shows up as number eventhough I have set it as "medium date" in the make table query.

Thanks in advance.

Answer 1

Why are you looking at the table? Use a form to display the data and format the control on the form.

Sorry, still a novice in Access. Not quite sure how to answer your question, but will give your suggestion a try though. Thanks.

Answer 2

Thanks for the reply.

I'll use this if there is no other solutions.

Answer 3

Why are you looking at the table? Use a form to display the data and format the control on the form.

Answer 4

Try writing an update query:

UPDATE YourTable SET [YourField] = Format([YourField], "mmm dd, yyyy")

--

Arvin Meyer, MCP, MVP

http://www.datastrat.com

http://www.accessmvp.com

http://www.mvps.org/access

co-author "Access Solutions" published by Wiley