Query similar data

[Guest]

Hi, I have a list of numbers in an access table that have a leading zero.
The table I am trying to query with has the same list but does not always
have this leading zero. Is there a way to do a similar type query? The
numbers are 10 digits. Thanks in advance, I'm very new to this.

 

[Bob M via AccessMonster.com]

If they have leading zeroes they must be text so if you want to compare the
two sets compare Val(your number)
Mathematicallly Val("00001")=Val("1")=1

 

[chris.nebinger]

Another way:

Where Right("0000000000" & [table1].[field1],10) = Right ("0000000000"
& [table2].[field2],10)


Chris Nebinger

 

[Guest]

thanks, that woks.

If they have leading zeroes they must be text so if you want to compare the
two sets compare Val(your number)
Mathematicallly Val("00001")=Val("1")=1