Count Unique Order #s

[Guest]

I have read several posts on this but I am not sure if any of the responses
apply to my situation.

So here is my situation and question.

Summary report based on single query.

Query has line item data that includes:

order_num
oder_date
item_num
line_ext_amt
etc.

Report summarizes daily activity and I would like to generate a count of
unique orders for that day.

Example
Date, Sale Amt, # of Order
09/01/04, 65000, 300

Right now I can get a total count of lines but each order contains many lines.

I could run another query off the first and summarize order data but I am
not sure how to include that other query in my report. I was hoping there
was some way to include 'Distinct' in the expression I build for count.

right now i have =count([order_num]) and that does give me a total of all
lines for that day. What I need is just a count of the unique order_num for
that day.

Thanks in advance,
Michael

 

[Duane Hookom]

You could group by Order_Num and show the group header. Add a text box in
the group header:
Name: txtOrderCount
Control Source: =1
Running Sum: Over Group

Then add a text box to the date footer with a control source of:
=txtOrderCount