How to query on last 4 digits of a 6 digit field?

[Infiltrator64]

I have a field that contains the month and year. Example 092006.

I want to prompt the user to enter just the year 2006.

What to i need to add to my access query prompt to only look at the last 4 digits?

 

[Norie]

What type of field is it?

If it's text you could use an expression like this.

MyYear:Right([YourField], 4)

 

[Infiltrator64]

Thanks that worked.