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?