I could use a little help...
I am building a report for an event planning database. I'm trying to put together a simple report that in the detail section will display the names of guests and the count of those attending. That part is simple and is working (e.g., each line says "Doe, Jane - 2 guests". Where I am having difficulty is in the page header of the report, I'd like to put a text box that shows "Total Guest Count - 34", where the 34 is a sum of the [number_attending] value from the detail records.
I've tried writing a concatenated string in the page header as follows...
="Total Guest Count - " & Sum(nz([number_attending]))
but this only returns an #error note in the report preview. The [number_attending] is a number value and is pulling from a query that the report is based on. Can anyone help in how to use a sum function in a concatenated field?