Report for Counting orders keyed

  • Thread starter Thread starter beccadawn0622
  • Start date Start date
B

beccadawn0622

I have to generate a report counting numbers of orders keyed by associates
and numbers of lines keyed. (There may be multiple lines on one order). I
need a formula to count only the unique records in the order number column.
for instance:

Operator Order Number Line Number
JSMITH 123456 1
JSMITH 123456 2
JSMITH 111234 1
JSMITH 123444 1

In this example, JSMITH keyed 3 orders with a total of 4 lines.

How can I get my report to calculate on the unique order numbers?
 
Is it okay to group the entries for an order number together?

If so:
1. Open the report in design view.

2. Open the Sorting And Grouping dialog.

3. Chose the Order Number field (after any other sorting/grouping rows you
need.) Choose Yes for Group Footer. Access adds a new Order Number group
footer to the report.

4. Set the Visible property of this new group footer to No (assuming you
don't want to see it.)

5. Add a text box in this neew group footer, and give it properties like
this:
Control Source =1
Running Sum Over All
Format General Number
Name txtOrderCount

6. In the Report Footer section, add a text box to show the number of
orders. Set its Control Source to:
=[txtOrderCount]
 
Back
Top