link unbound textbox to totals in a query

[mev2018]

I was hoping this would be an easy one to solve, but nothing has worked. The basics of what I have setup:


1. I have a query created which displays all records of one field from my main table called 'serious incidents'

2. The query has a running total of the number of records.

3. on a report which has my pie chart - this is a chart related to my query, I wanted to link an unbound textbox to the totals field in the query, but being a query, the field doesn't exist.


I am seeking some advice on what to do as it seems my attempts has been futile.

I have tried COUNT and DCOUNT of the related field called 'related incidents' but I either get an error most of the time. Any help is appreciated.

Wayne

 

[ranman256]

If the form is continuous,and shows all records,
in the form footer,put a textbox.
source= Count(field)

 

[mev2018]

If the form is continuous,and shows all records,
in the form footer,put a textbox.
source= Count(field)

Thank you for your reply, I managed to solve it, I was a bit silly and forgot to add (*) to my code for dcount.

Thanks
Wayne