Count on the page

[Rodolfo Fontes]

Hi group,

I have a report with the following SQL, that list all sold products and
their quantities.
I wanna count them all, sold products, at the final of the page.
The products are already been listed on the page.
For that, i tried , count(ContarDeQtd_NF), and get error message.
Any idea?

SQL:
SELECT Count([T NF_S_Det].Qtd_NF) AS ContarDeQtd_NF, [T NF_S_Det].[Part#F]
FROM [T NF_S_Det]
GROUP BY [T NF_S_Det].[Part#F]
ORDER BY Count([T NF_S_Det].Qtd_NF) DESC;


Tks,
Rodolfo Fontes

 

[Duane Hookom]

Make sure you have your count text box in the report footer, the name of the
text box is not also the name of a field, and you must include the "=" in
the expression:
=Count(ContarDeQtd_NF)
These should also work the same:
=Count(*)
=Sum(1)