I have a convention registration database I put together several years ago. In my check-in form I was using a Combo box to select between Yes and Null for setting my "Present" field. This was prone to errors by my registration volunteers so I changed it to a check box. That change broke all my reports. I have a crosstab sub-query that gave me a count of the number of delegates and alternates present for each district. The count depended upon having a Null value for not present. Check boxes do not allow Null, and the count picks up both the yes and the no values. I'll be darned if I can come up with a way to tweek the existing reports/queries so they give me a count of Present = True.
Thanks in advance for any help
Thanks in advance for any help