Search results

My database is a maintenance record of our building complex. The unit/building number is the key field. The problem I am having is having access recognizing the unit numbers and building numbers, not as whole numbers. Example: I-380, 10-380, 2-390, 13-370, and so on. When sorted, access treats...