comapring

[canberry]

i am using the find unmatched query wizard to create to do some coparisons. However, a field i am camparing is represented as the end character of another feild [(eg) staff charges 10]. I want to compare the 10 from that cell to another table that conatains a feild with all these values. eg. Table 1 Table 2
Column a Column b
staff charge 4 4
custumer 22 8
staff waive 8 22

 

[MSAccessRookie]

i am using the find unmatched query wizard to create to do some coparisons. However, a field i am camparing is represented as the end character of another feild [(eg) staff charges 10]. I want to compare the 10 from that cell to another table that conatains a feild with all these values. eg. Table 1 Table 2
Column a Column b
staff charge 4 4
custumer 22 8
staff waive 8 22

Check out the Right() command. I believe that it will be helpful to you.

Right(String, NumberofChars)

 

[canberry]

This function does what i need. Thanks much