Date format in a make table query

P

PhilM

Hi,

I have a working make table query that has a date as one of the
fields. Is there any way I can force the query to format the date as
dd/mm/yyyy in the new table?
 
J

John W. Vinson

Hi,

I have a working make table query that has a date as one of the
fields. Is there any way I can force the query to format the date as
dd/mm/yyyy in the new table?
Click to expand...

No. And there's no need to do so, usually - users shouldn't be looking at
tables (or except in the rarest of circumstances, running MakeTable queries).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting date gives bad results in query 2
Format DATETIME to Date in query on linked table 4
query on date 1
Append/Update Query 6
Date format in query export. 4
Date Function in query 3
date mismatch in query..do not know how to solve 3
extract just month/year from table field?? 2

Top