Query to return partial field

[jhairusw]

I have a sixteen digit field, I need to pull only the last four digits in the query.


Thanks

 

[roelandkim]

Try this in your query.

Right([fieldname],IIf(InStr([fieldname]," ")>0,InStr([fieldname]," ")-1,4))

 

[jhairusw]

Excellent! Thanks!