Problem with Grand Total

  • Thread starter Thread starter CB
  • Start date Start date
C

CB

I have a very simple report based off of a query that I
created. The query was very simple. Account Number and
Name are the only two fields on it. I have it set up so
that only unique records appear in this query.

On the report, I would like, at the bottom of the page,
to have a Total number of accounts. I clicked on the
footer and built an expression. This is what I used:
=Count([Account #])

When I try to view the report, I get an error message:
The function you entered cannot be used in this
expression. Does anyone know what I might have done
wrong?
 
CB said:
I have a very simple report based off of a query that I
created. The query was very simple. Account Number and
Name are the only two fields on it. I have it set up so
that only unique records appear in this query.

On the report, I would like, at the bottom of the page,
to have a Total number of accounts. I clicked on the
footer and built an expression. This is what I used:
=Count([Account #])

When I try to view the report, I get an error message:
The function you entered cannot be used in this
expression. Does anyone know what I might have done
wrong?
Click to expand...


It sound like you tried to use that function in a page
footer section. The aggregate functions will only work in
the report and group headers/footers where they can
determine the set of data to operate on.

I think you might get what you want by moving that text box
to the report footer section. If not, post back with more
details about what you're trying to do.
 
That worked, but now I have another issue. It didn't
work as I had planned. I don't know if you will be
coming back to this post so I will start a new one just
in case.
-----Original Message-----
CB said:
I have a very simple report based off of a query that I
created. The query was very simple. Account Number and
Name are the only two fields on it. I have it set up so
that only unique records appear in this query.

On the report, I would like, at the bottom of the page,
to have a Total number of accounts. I clicked on the
footer and built an expression. This is what I used:
=Count([Account #])

When I try to view the report, I get an error message:
The function you entered cannot be used in this
expression. Does anyone know what I might have done
wrong?
Click to expand...


It sound like you tried to use that function in a page
footer section. The aggregate functions will only work in
the report and group headers/footers where they can
determine the set of data to operate on.

I think you might get what you want by moving that text box
to the report footer section. If not, post back with more
details about what you're trying to do.
Click to expand...
 
Back
Top