Prev: 'asctrls.ocx' error
Next: Combo Boxes
From: joelgeraldine on 17 Mar 2010 09:51
jkjkjk

"inspirz" <inspirz(a)discussions.microsoft.com> a écrit dans le message de
groupe de discussion : 4E2BCB1D-0662-44CB-BE79-D3AE57BB0EF5(a)microsoft.com...
> 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