Need Help with Report Calculations (2000)

[masterd]

Hi,
I have a table called Parts. it's primary key is partsID. It's linked to another table called MachineInfo. There is another field called RecSource where we identify per part what source it will get ordered from (ie. Vendor, OEM, Tool Room). I have a form set up as a dialog box where the user chooses the machine then the RecSource and it lists the parts for that machine for that recsource. On this report I'd like to have 2 counts, one that counts the records on the report, this one I have no problem with. The other count I'd like to see is the total number of parts for that machine no matter what the recsource is. Can this be done?
Thanks,
Deb

[HansV]

You can use the DCount function. Its general form in the control source of a text box is

=DCount("[NameOfField]", "[NameOfTableOrQuery]", "WhereCondition")

If you need more help, please provide more information where the information about all parts for a specific machine is stored.

[masterd]

Thanks Hans,
I've tried the following and I am getting an error. =DCount("[lngPartsID]","[qryPartsStatusUnion]","[strMaterialJON]=[cboDPLSelectReport]"). I'm assuming that my syntax for the condition is wrong. strMaterialJON is part of the query and the cboDPLSelectReport is the combo box on the form that the user selects before they view the report.
Thanks,
Deb

[HansV]

You have to refer to a combo box on a form as [Forms]![NameOfTheForm]![cboDPLSelectReport]. The form must still be open.

[masterd]

Thanks Hans, how soon we forget the little things. That did it. Thanks a ton. Deb