Record totals in group footer

[Guest]

G'day,

I have a report that lists all current prospects with relevant details.
Current prospects each have a Corp Office Rep (COR) that looks after them and
the report, via the use of group headers and footers lists all current
prospects per COR.

A prospect may become non-current, and they are either current or
non-current via a yes/no box.

In the group footer I have some calculations that determine conversion rates
from prospect to owner.

As the report has a filter, via a query, that only list current prospects,
the calcs in the group footer are only based on current prospects - how do I
get the calcs to include all prospects???

Using DSum etc sourcing directly from a table, does not allow me to split
between COR's - any ideas at all, please???

 

[tina]

if each record in the table (or in a query) has a COR field, you should be
able to use a DSum() function with criteria, as

=DSum("some field name", "table or query name", "COR = " & CORFieldName)

the above goes all on one line, of course. if the COR value is text, rather
than numeric, the syntax would be

=DSum("some field name", "table or query name", "COR = '" & CORFieldName &
"'")

again, the above goes all on one line. you can read up on domain aggregate
functions in Access Help to better understand how the criteria argument
works.

hth

 

[Marshall Barton]

I have a report that lists all current prospects with relevant details.
Current prospects each have a Corp Office Rep (COR) that looks after them and
the report, via the use of group headers and footers lists all current
prospects per COR.

A prospect may become non-current, and they are either current or
non-current via a yes/no box.

In the group footer I have some calculations that determine conversion rates
from prospect to owner.

As the report has a filter, via a query, that only list current prospects,
the calcs in the group footer are only based on current prospects - how do I
get the calcs to include all prospects???

Using DSum etc sourcing directly from a table, does not allow me to split
between COR's - any ideas at all, please???

I think you should create a separate query and report that
calculates and displays the desired totals. THen use that
report as a subreport in your current report.