date format lost in UNION query
instead of setting the "format" property of the field in the queries, you
will need to "format" the field directly. Something like:
Select Format([Eval Date], "mmmm d") as EvalDate
FROM yourTable
and will have to do this for both parts of the union query. This will
obviously change this value from a date to a string.
----
HTH
Dale
"Marge" wrote:
The design view property for [Eval Date] of each of the queries used to
create the union query is set to format mmmm d. I am not taking the date to
a form or a report; I am creating a make table to add to another query which
will convert to Excel.
"KARL DEWEY" wrote:
instead of January 10 as my formatting in the design view properties
instructs (mmmm d).
Design view of what?
Are you not taking the data to a form or report? Format there.
--
Build a little, test a little.
"Marge" wrote:
I've merged the results of 2 queries into a UNION query, however I suspect
that one of the fields [Eval Date] has lost it's date format. The reason I
think so is that the field displays as 1/10/06 instead of January 10 as my
formatting in the design view properties instructs (mmmm d). How can I
resolve this? Thanks for any help you can lend.
|