Unanswered: Microsoft Access validation check expression problem
I'm creating a database in Micrsoft Access to hold book records, so one of the fields I've got is 'Shelf Number' which is the 532.25 or whatever you get on the spine, and I'm trying to put in a validation check for the field so that it will accept "FIC" and any number under 1000 with any number of decimel places but I can't seem to get it to work. Currently I have;
Like "FIC" Or "<1000"
But it doesn't seem to matter what I do, I can't get it to accept all the values - either it will accept "FIC" or the numbers, not both.