G
ggerke
Hello All,
I have a table with a number of different records sorted into 10 different
divisions. Each division has multiple items. I created a query based on this
table and grouped the divisions so I could sum up the items. I then totaled
this sum in the datasheet view of the query.
I have then created a form, where I would like to display each division and
their respective totals in a continuous forms type format. I would then like
to show the grand total in the form footer, here-in lies my problem. How do
you reference that grand total from the datasheet view of the query, or show
the grand total of the 10 divisions along with the division totals in a form?
(PS, I have tried using the =Sum([SumofItems]) function in the form footer
but that returns an error. (There are no Null values).
Your help is much appreciated.
I have a table with a number of different records sorted into 10 different
divisions. Each division has multiple items. I created a query based on this
table and grouped the divisions so I could sum up the items. I then totaled
this sum in the datasheet view of the query.
I have then created a form, where I would like to display each division and
their respective totals in a continuous forms type format. I would then like
to show the grand total in the form footer, here-in lies my problem. How do
you reference that grand total from the datasheet view of the query, or show
the grand total of the 10 divisions along with the division totals in a form?
(PS, I have tried using the =Sum([SumofItems]) function in the form footer
but that returns an error. (There are no Null values).
Your help is much appreciated.