Greetings!

I am trying to write a simple parameter query to search a field containing "#123456" as the data format. I need to be able to find all that end in a given number. I believe that the wildcard in the field is causing me trouble. I have tried " like "[#] *" & [last digit]" , = "#" & "*" & [last digit], = "#" & "#####" & [last digit], and = "#" & "?????" & [last digit], all without success. Does anyone have any suggestions? Thanks!

Assuming you're looking for all ending in 6, this would work:

Right([FieldName],1) = 6

You could also use: like "#####6"

Mike