Need to Query last 6 digits of field

[kmclane]

I have a field with a 16 digit number in it. The first 10 are all the same. I am trying to set up a query that will allow users to input the last 6 and get a match. I'm not sure how to do this. I thought I could do it in the criteria field, but I don't know exactly how to start?
Any suggestions would be appreciated. Ken

 

[Cbrine]

You want to use a custom query field.

Field Name in Query
Test: right([Field Name],6)

[Field Name]=Your Field Name

Criteria
[Last 6 digits]

This should cause the query to prompt you with an input box for the 6 digit number.(You won't be able to set any validation, so the user could input a 12 digit number, if you want validation, I would suggest setting up a form to pass the parameter)

Hope this helps.

 

[kmclane]

Here is the code, I have tried to change it in the way you suggested, but I keep getting errors, so I must be doing it wrong.

SELECT CurrentARUMonth.TerminalNumber, CurrentARUMonth.Date, CurrentARUMonth.Time, CurrentARUMonth.CardNumber, CurrentARUMonth.ExpirationDate, CurrentARUMonth.PurchaseAmount, CurrentARUMonth.AuthCode
FROM CurrentARUMonth
WHERE (((CurrentARUMonth.TerminalNumber)=[Enter Last Six of MID]));

Can you tell me where it goes? I tried incorporating it into my WHERE, but it didn't work.

Thanks, Ken