View Single Post
  #3  
Old December 8th, 2009, 06:26 PM posted to microsoft.public.access.queries
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default date format lost in UNION query

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.