How do you format date fields of a Union Query in MS Access?

Question

I have two tables with date fields. Each table displays the date in Short Date format (MM/DD/YYYY).

I wrote a Union Query to combine these tables, but the Union query displays the date in General Date (long) format (MM/DD/YYYY HH:MM:SS). I would be grateful for a solution to getting dates out of the Union Query in Short Date format.

Answer 1

If you are using a querydef, you can right-click on the column in Design Mode and you will find a Format property.

Answer 2

do a select on the union and format the date column at the end:

select format(foo, "short date")
from (
    blah
union
    blah
)

Answer 3

There's a nice built in Jet function you can use:

Select Format(myDate, 'mm/dd/yyyy') From Table

Hope this helps!