Query similar data

X

xgirl

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.
 
B

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
 
C

chris.nebinger

Another way:

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


Chris Nebinger
 
X

xgirl

thanks, that woks.

Bob M via AccessMonster.com said:
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
Click to expand...
 
Top