criteria to search from Right

[Haggr via AccessMonster.com]

how to search records from the Right using the last 2 digits Ex. "22" would
return record "14522"

 

[Perry]

Use the right function:
? Right("14522", 2)
22
http://msdn2.microsoft.com/en-us/library/eh8fefz1.aspx

Or Mid() function
s = "14522"
? mid(s, len(s)-1)
22
http://msdn2.microsoft.com/en-us/library/05e63829.aspx

Krgrds,
Perry

 

[Haggr via AccessMonster.com]

thanks.

Use the right function:
? Right("14522", 2)
22
http://msdn2.microsoft.com/en-us/library/eh8fefz1.aspx

Or Mid() function
s = "14522"
? mid(s, len(s)-1)
22
http://msdn2.microsoft.com/en-us/library/05e63829.aspx

Krgrds,
Perry

 

[John Vinson]

how to search records from the Right using the last 2 digits Ex. "22" would
return record "14522"

Use a criterion

LIKE "*" & [Enter search term:]

If the user types 22, it will find 14522, 32131241222, 22, or any
other string ending in 22.

John W. Vinson[MVP]