From: joelgeraldine on

"inspirz" <inspirz(a)> a écrit dans le message de
groupe de discussion : 4E2BCB1D-0662-44CB-BE79-D3AE57BB0EF5(a)
> Hi,
> In a Select Query I'm joining 2 tables by Item ID (unique value, similar
> to
> Social Security Number) but 1 table created by IT has Item ID as a
> "number"
> value and the other table has it as a "text" value.
> How can I in a Select Query, create a formula that can either have the
> text
> as a number value and vice versa so i can link the 2 without getting "type
> mismatch in expression."
> I think I can use Cdbl Value or something like that in the formula but not
> sure.
> Thanks!

First  |  Prev  | 
Pages: 1 2
Prev: 'asctrls.ocx' error
Next: Combo Boxes