I have an SQl query on a form to display total from a table using a procedure. Iam using Label as Display Format. I am able to display correct number when there is data but when there is no data in the SQL table it displays nothing on the form.
I want it to show 0. When I test the query using Run Now in the designer it does show 0 ,, I am not sure why it cannot display the same 0 on the form.
In the pic you can see "Year 1 count" is a column in my list
"Total_Count" is the output column in the database. I am not sure if I selected all this right
Any ideas please.