Sum values in concatenated fields

[jdrubins]

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?

[lloyddobler]

what happens if you remove the nz function?

[jdrubins]

If I remove the nz function, I still get the error message. The statement as it is written works in the report header... but not in the page header. Trying to get it there so it shows on each page.

[lloyddobler]

I've had that happen for no reason too. I usually copy/paste from another section or another report where it's doing similar and that has worked. Have you tried copying from the report header?

[jdrubins]

Tried pasting back from the report header into the page header... but no luck. Still getting the error message.