View Single Post
  #4  
Old December 8th, 2009, 08:08 PM posted to microsoft.public.access.queries
Marge
external usenet poster
 
Posts: 84
Default date format lost in UNION query

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.