Counting distinct records on a report (1 Viewer)

[kully]

I have a report which details products on certain order numbers - So each order number could appear many times if it has many products. I want to count how many distinct order numbers there are in total (not how many records appear on my report)
Am I making myself clear????

Can you please help as I cannot seem to do this.

Thanks in advance for any help.

 

[Matt Leidemer]

You can use DISTINCT or DISTINCTROW:

select distinct field from table where...

select distinctrow field form table where...

distinct is used in standard SQL queries.

distinctrow is used in Access.

HTH

- Matt

 

[kully]

I still can't seem to do it. I want the total to appear in my report header. I am quite a novice at this so I may need step by step instructions.

 

[KevinM]

Use the Report Wizard to create the report and when is asks 'Do you want to add grouping', select by Order Number and include a total in the group footer. There is no extra work needed on your behalf.