Union Query Select

[Warrio]

Hi, I want to do a Union query in which there would be a condition.


Ex:

Select Debit.Référence as Réf
From Debit
Where (((Debit.Référence) Like "*" & [Forms]![Motor]![Text0] & "*"))
Union
Select Credit.Référence as Réf
From Credit
Where (((Credit.Référence) Like "*" & [Forms]![Motor]![Text0] & "*"));

It tells me the following Error

Cannot use Memo, OLE, Hyperlink Object field 'Référence' in the SELECT
clause of a union Query.

When I take of the Union with Crédit it works.

Is there a way to do this Union with the condition?

 

[HSalim]

Convert the field to a string using cstr(credit.reference)
HS