These 2 SQL alone works:

(1)

SELECT DatumCas, PridelTypOperace("zmìna") AS TypOperace, PridelHodnotyOperace("zmìna", Zaznam, "Støedisko",StrediskoOLD,StrediskoNEW) AS HodnotyOperace
FROM [Monitorování zmìn - Evidence PC/Støedisko]

(2)

SELECT DatumCas, PridelTypOperace("zmìna") AS TypOperace, PridelHodnotyOperace("zmìna", Zaznam, "Poznámka",Cstr(PoznamkaOLD),Cstr(PoznamkaNEW)) AS HodnotyOperace
FROM [Monitorování zmìn - Evidence PC/Poznámka]


------------------------------
When I join them together, then the Microsoft Access 97 programme crashes:

(1)

UNION

(2)

I know it is because of the (2) uses MEMO fields but even if I convert them to CSTR()...

But (2) alone works, but with UNION it crashes. But if I UNION (1) with similar query that does not SELECT MEMO fields it does not crash....


strange....