I have a table with customer estimates and sales. I need a report to reflect the closure rate by total number of jobs within a given section (in this example subdivided by lead source). Each job can have multiple records. I need to get the % based on grouping estimates for specific jobs. (7 estimates that all begin with the same first 5 characters belong to the same job and should be counted as 1 job not 7). I got the report to group and count. What I can't seem to do is to calculate the % based on the "grouped" field. Can you do a DCount combined with a "left([fieldname],5)(for grouping) and then divide that field by another DCount where the [sales amount] for that record is >0. I get an #Error when I run this and can not seem to find much information about this type of calculation using DCount.
January 5, 2009 1:35 AM
January 5, 2009 2:18 PM