Calculate number of records

  • Thread starter Thread starter Linda
  • Start date Start date
L

Linda

I am working on a sales report that is sorted by realtor.
I need to total the amount of sales that each realtor
has. I know that =Count(*) will give me all records on
the page, and that =Count([sales_id]) will give a total
for all sales records. Is there a way to calculate the
number of sales for each realtor?
 
Group the report by Realtor then put the Count text box in the Group footer
rather than the report footer.

Evi
 
Linda:

To do the count per realtor you have a few options.

1.) Add the realtor ID to your reports query and then create a group header
and footer for the realtor ID and use the count function.
2.) If the above is not practical, then you can also use the DCount()
function in some other section, however, you'd still need to have the
realtor ID of some type to send to the DCount() function.
 
Back
Top