Query

[cornishteeth]

I need to create a parameter query that returns the last digit of the persons social security number when user inputs it. I just don't know what formula to put in the criteria. Something on the lines of

[Enter Last Digit of SSN]
(What would be added to return the last digit?)

Thanks,

Frank

 

[Norie]

Frank

What exactly do you mean?

Do you want to use the last digit as criteria? Or do you want it as the result?

 

[cornishteeth]

I would like the user to be able enter the last digit of a persons social security number and have the query return everyone with that input. For example, The user inputs the number 2, and all records ending in two are displayed.

Thanks,

Frank

 

[Norie]

Frank

Maybe Like "*" & [Enter Last Digit of SSN]

 

[cornishteeth]

Thanks. Works great.

Frank