Excluding phone numbers using a query

[Scott O'Neal]

OKay, here's the lowdown, I have written a simple query to list the phone numbers I have entered into a client database. I have 3 fields in my table, (autonumber, date, and phone number). I wrote the first query and it produced a list of phone numbers dating back to the inception of the database. I then added a critria statement to limit the list to the last 31 days, >Now()-31. Now I need to get rid of any local phone calls that were placed, showing only the phone numbers outside of the 615 area code. I have tried quite a bit, but nothing is working. Any tips or suggestions?

Thanks,
Scott ☺

[JoeM]

You haven't specified the layout of your phone numbers, but if it is all numeric, any you want to exclude phone numbers beginning with a 615 area code, you could use the criteria:

LEFT([phone number],3)<>"615"