I have added a field to the main log form called DIRECT that is a logical field. The data base contains 152 records, 5 have true and 147 false in the DIRECT field. I go into the report menu and pick address labels 3-across no duplicates.

If I run the report as is with the default filter QSL_Sent = "R" it prints 3 records. On the run report options screen I click on the filter and click on clear then enter the value "n" in the (user)DIRECT field, and click on the count matching records which returns 147 which is correct.

I close the filter and the criteria displays NOT TAG_VAL("DIRECT:", USERFIELDS, "L"). I select print and it only prints 8 records. I go back to the filter clear it and enter "y" in the field value for (user) DIRECT field click on count and it counts 5 records which is also correct. I close the filter and the criteria is TAG_VAL("DIRECT:", USERFIELDS, "L") select run and it prints three records.

What am I missing?

Dave, NW#U

Dennis, thanks for looking at this. A backup of my db is attached. Yes ther should be 5, W9OO, HB30OK, KN8I, KK4EOG and NW3U. Interestingly using the filter I created it prints KN8I, KK4EOG and NW3U it prints the same three using the default QSL_SENT = "R" filter. The QSL_Sent field value in the five are in order F,F,R,blank,blank. Hope this helps. I should have mentioned that the log entries were imported from CommCat then the fields were added to the form. It appears thst new records may work correctly. I'm going to clear all entries from log form and reimport the log entries from the CommCat adi file into the db with the fields already defined. Well No Joy with all log entries having False (f) in the field the report only finds 4 records that match. I should also mention that using the filter from the main log form works correctly. Thanks again.

Dave, NW3U

Dennis; I believe you're right. I missed this. I withdraw the the issue. No need you spending any more time on this. If I discover any other issues I'll start a new topic.

73's

Dave NW3U