[AccessD] text changes into date

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;