I've drawn a blank.. need help creating a query. I have a field (field1) on a view form that I want to search for all records that do not contain symbol "/" (forward slash). Example of data in field: ABC/123 ABB ABC/345 DEF/555 DEF XY
I only need the query to return ABB, DEF, XY. I can do 'field1' LIKE "%/%" ---but how do I do the opposite? I've tried: 'field1' != "%/%" ---this does not work. Thanks for the help, Marcelo _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"