I've seen several threads on the Dcount topic, and I've tried Access help, to no avail.
I have one master table (named master) that holds all the data pertaining to selling a car.
I have several reports pulling various info - by salesperson, finance person, new/used, etc.
I need to create another report separated by finance person that totals how many new or used cars they sold and calculating some of the fields.
For example, lets say Chris financed 4 new car deals. I can run a query for that, but it pulled individual deals, not a group total. In the report I need to pull the count - in other sections I'll need to pull various figures, but I think once I figure how, then I can manipulate the code.
I have one master table (named master) that holds all the data pertaining to selling a car.
I have several reports pulling various info - by salesperson, finance person, new/used, etc.
I need to create another report separated by finance person that totals how many new or used cars they sold and calculating some of the fields.
For example, lets say Chris financed 4 new car deals. I can run a query for that, but it pulled individual deals, not a group total. In the report I need to pull the count - in other sections I'll need to pull various figures, but I think once I figure how, then I can manipulate the code.