Need total of orders in report

[Guest]

In the report footer I inserted =Count([OrderID]). Instead of getting total
orders, I am getting the total of line items for those orders. The OrderID is
in a group named OrderID. I would appreciate it if someone would give me some
direction.
Thanks, Ron

 

[Duane Hookom]

"Total of orders"? Do you mean count the number of unique orders? If so, you
can add a text box to your OrderID group header:

Name: txtRunSumOrderID
Control Source: =1
Running Sum: Over All
Visible: No

Then, in your report footer, add a text box with a control source of:
Control Source: =txtRunSumOrderID

 

[Guest]

Thanks Duane
That was perfect.

"Total of orders"? Do you mean count the number of unique orders? If so, you
can add a text box to your OrderID group header:

Name: txtRunSumOrderID
Control Source: =1
Running Sum: Over All
Visible: No

Then, in your report footer, add a text box with a control source of:
Control Source: =txtRunSumOrderID

--
Duane Hookom
MS Access MVP

In the report footer I inserted =Count([OrderID]). Instead of getting
total
orders, I am getting the total of line items for those orders. The OrderID
is
in a group named OrderID. I would appreciate it if someone would give me
some
direction.
Thanks, Ron