This should be straight forward. I have a database I've constructed myself through self teaching so please be patient.
There are 2 tables; UnitsT, ComplaintsT.
I have a main menu form that has several buttons to pull up various other forms for entering new complaints, editing complaints, and a continuous form to view all complaints saved.
I am adding more functionality to the main menu and have now wanted to include text box fields that show the total complaints received and non-violations (these are a check box in on of the columns in the ComplaintsT table).
The text box on the main menu for total complaints works perfect. In the Control Source field under Data tab I entered: =Format(DCount("Address","ComplaintsQ"),0)
This returns the total count I have in a Query (ComplaintsQ) that pulls from the complaints table. The Query has totals at the bottom set to count for the Address and Non-Violation fields.
However I've tried may different ways for the Non-Violations text box and get this error. And have spend countless hours digging online. I feel it has to do with the checkbox and maybe how it reads the -1 and 0. I'm not sure.
If there is someone out there willing to throw me some knowledge. It would be much appreciated.
There are 2 tables; UnitsT, ComplaintsT.
I have a main menu form that has several buttons to pull up various other forms for entering new complaints, editing complaints, and a continuous form to view all complaints saved.
I am adding more functionality to the main menu and have now wanted to include text box fields that show the total complaints received and non-violations (these are a check box in on of the columns in the ComplaintsT table).
The text box on the main menu for total complaints works perfect. In the Control Source field under Data tab I entered: =Format(DCount("Address","ComplaintsQ"),0)
This returns the total count I have in a Query (ComplaintsQ) that pulls from the complaints table. The Query has totals at the bottom set to count for the Address and Non-Violation fields.
However I've tried may different ways for the Non-Violations text box and get this error. And have spend countless hours digging online. I feel it has to do with the checkbox and maybe how it reads the -1 and 0. I'm not sure.
If there is someone out there willing to throw me some knowledge. It would be much appreciated.