View Full Version : Searching for errors


rfrey
03-30-2001, 04:23 PM
I have a database setup that stores sleeves for the printing industry. The fields used are field 1, field 2 and Size. They come in various sizes which I give locations to(the sleeves are nested or stored inside each other). For instance a 14" will fit between a 13" and a 15", but a 14" will not fit between a 13.25 and a 15". I need a 1" cushion for each sleeve. My question is, after I assign locations for new sleeves is there a query I can run that will show me if I've given locations that obviously won't work. Any help would be greatly appreciated.