[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;