View Single Post
  #5  
Old December 8th, 2009, 09:10 PM posted to microsoft.public.access.queries
Dale Fye
external usenet poster
 
Posts: 2,651
Default 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.