Can you identify the record that is found by 2 and not by 1?
Could it be that it is a record that falls in the date range and looks like it has an empty field that isn't actually empty?
A field can look empty but not actually be empty if:
- There is a nonvisible character such as a space, tab or return character in the field
- If the field is formatted with check boxes or radio buttons and there is data in the field that does not match any of the values listed in the value list used for the check boxes or radio buttons. (This can happen when there is data in the field first and then the check box or radio button field is either added or changed.)
Thanks for the quick reply. The field is a check box. Only one choice: yes or it is left blank..q I will check the value list on the database not working correctly.
I will have access over the weekend.
I suggest taking the layout where you see this field and making a copy of the field. Then remove the check box format from the copy. Find the record in question and double click the edit box copy of the field while in browse mode. If there is any text in the field, the double click should highlight a portion of the field even if there is no visible data in it.
I should be able to work on the database tonight. I will do that as well as side by side comparison of what each database returns.
Keep you posted,
Thank you thank you thank you. I did as you suggested and although there did not appear to be any characters, when I deleted what was there the search worked properly.
Now to figure out why my applescript with in a FM script does not run correctly in Mavericks and I will be good to go.