[AccessD] text changes into date

Hi Pedro

You can have it displayed as you like (nearly), but that doesn't change the data type.

/gustav

>>> pedro at plex.nl 20-08-2008 21:17 >>>
Hello Gustav,

thanks it works perfect.
I always thought that, when formatting a date field, you display it as you 
like.

It has been some years ago that i was a regular access user. I believe that 
i am a little bit rusty now.

Pedro


----- Original Message ----- 
From: "Gustav Brock" <Gustav at cactus.dk>
To: <accessd at databaseadvisors.com>
Sent: Tuesday, August 19, 2008 10:23 AM
Subject: Re: [AccessD] text changes into date


> Hi Pedro
>
> How about formatting that date field:
>
> SELECT
>  Histologie1.Pnr,
>  Histologie1.datumontvangst,
>  Histologie1.rapportnummer+" "+Format(Histologie1.datumontvangst, 
> 'dd-mm-yyyy')+" "+Histologie1.diag1 AS diag,
>  Histologie1.rapportnummer
> INTO
>  hist2
>
>
>>>> pedro at plex.nl 19-08-2008 10:10 >>>
>
> Hello Group,
>
> i use the query below to fill in data in the expression: Diag
>
> Diag (in hist2) is a field with datatype is text. However because 
> Histologie1.datumontvangst is a date-field (rapportnummer and diag1 are 
> text-fields), the tabel-field diag in hist2 changes itselfs to datatype 
> date/time and stays empty.
>
> How can i adjust this so that "diag" stays a text-field.
>
> Thanks
>
> Pedro Janssen
>
> SELECT Histologie1.Pnr, Histologie1.datumontvangst, 
> Histologie1.rapportnummer+" "+Histologie1.datumontvangst+" 
> "+Histologie1.diag1 AS diag, Histologie1.rapportnummer INTO hist2
> FROM Histologie1
> WHERE (((Histologie1.rapportnummer) Like "T*"))
> ORDER BY Histologie1.Pnr, Histologie1.datumontvangst;