Hi

I am working with the Medicare Provider Number. The number always consists of 6 digits. The first two identify the State in which the provider is located. The last 4 digits signify the type of facility. Critical Access Providers, for example, all have a number with the last 4 digits ranging from 1300-1399. My question is can I add a criterion to an Access 2010 query that scans the provider numbers ranging from 000001-759999 and returns only those providers with the last four digits ranging from 1300-1399?

Thank you for taking the time to read/consider this request.

Al Charbonneau