Using a query to count the number of records for a stock database.
When there are no records the query just returns the headings of the columns. How do I get the query to return "0" for no records?
Thanks for any help to this probably very simple problem!
Sorry the quaestion was probably a bit vague
The query looks at a table.
The two fields are [Assigned?] and [AssignedTo?]. [AssignedTo?] is a true false. So I set the query up to look for false results. In the [Assigned?] I have used the Count on the Total row of the query.
If I have no records I get nothing but the column headings, if I change [AssignedTo?] to true (look for true records) I get the number of true records. I may have set this up wrong to start with?
I then grab this figure from another form, but I cannot pass the null value hence why i need a zero.