ddreese Posted February 2, 2005 Share Posted February 2, 2005 Ok, so I thought I knew searching well enough. Say I go into find mode on a layout. I want to find all records that are under the age of 18 that also have information (non-blank value) in another field. I type in (field names in parenthesis): (File Number) = (Age): >17 Click -> Omit Record Click -> Find ------------------------------ I get 2745 records with that search. When I search for JUST file numbers that aren't blank, I only get around 1000. Therefore I must be getting the blank file numbers plus EVERYONE who is >17 years. I had always assumed that if you enter in multiple fields on the same request it acts like an 'AND'. i.e. find all records that have a blank value in the file number field AND the age is over 17. Age is a calculated field, and it's not a problem with the field because I can do a find on just that field of >17 -> Omit and it works absolutely fine. File number is a number field, searching just on this field works fine, as well. Someone please help, this is making no sense to me. My search (eventually a script) will be much more complex than this, but if I can't even get THIS correct, there is no point going forward. Link to comment Share on other sites More sharing options...
This topic is 6626 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now