Adding count and other details

[KurtL]

Im creating a where used report (see attached) and i would like to add a few details to the end of the report.

PART NO. TOTAL:
I would like to add a count of the different part numbers(far left column). The total right now should be about 514 but when i create a text box with the string =Count([PART NO]) i get a result of 838. If you add up the numbers in the far right column thats what you would get.

ASSEMBLY TOTAL:
I want to add a count of the differnet assemblies (column 2) that are present in the report. There are only 18 different assemblies currently. when i attempt =Count([ASSEMBLY NO]) i again get 838.

Do i need to include new tables into the report (i.e. my assembly table and part number tables)? And how do i do this. Im new to this and havent figured out how to add new tables or queries to the report w/o the wizard.

Thanks
Kurt

 

[statsman]

Did you put your count in the Report Footer?
That's where it belongs.