Form based on crosstab - sum in footer

[Zedleb]

Scared off by all the talk of dynamic crosstab hell I thought I would just settle for displaying my crosstab query in a form - and live with the #Name errors in the empty columns.

My aim is to show how many enquiries we receive on what topic in which area. So area as column headings, enqury topic as row and count the enquiries. It works fine and I have a total column for the number of enquiries on each topic - but I want to be able to sum how many enquiries in each area (the columns). I thought that putting a text box =Sum([fieldname]) in the form footer would work but I get a #Name error.

Can anyone help - or suggest a better way of doing what I want.
Many thanks.

 

[BLeslie88]

Hmmm...

Listen bud, I do not fully understant what your problem is. Here is one solution.. Putting a subform in the footer that has the results. Only other suggestion is to minimize the size of your db, zip it and post it with your reply and i will look at it....

Regards,
Brian K Leslie