Count Combinations of fields in Group Totals 1

[Comp2008]

I’m trying to do get a total count between two fields: [Appointment Kept] and [Internet Source]. The name of the table is “BDC Info Table”.
I have this expression which works perfectly in the Report Footer (Grand Totals)
Code:
=DCount("*","[BDC Info Table]","[Appointment Kept] = True And [Internet Source] = 'AutoUSA'")

When I type the same expression in the Group Total, it gives the same number. It doesn’t calculate as a group Total (the group name is Location Name). I tried all kind of possibilities and all my attempts failed. ex:
Code:
=DCount("*","[BDC Info Table]","[Appointment Kept] = True And [Internet Source] = 'AutoUSA' and [Location Name]")
Code:
=DCount("*","[BDC Info Table]","[Appointment Kept] = True And [Internet Source] = 'AutoUSA' and [Location Name] = & [Location Name]")

If you have any suggestions will be greatly appreciated.
Thank you in advance.

Comp2008

 

[dhookom]

Don't use DCount() in a report if you want to calculate from records in your report or report section. You should be able to use this same control source in report and group headers and footers:

=Sum(Abs([Appointment Kept] = True And [Internet Source] = "AutoUSA"))

Duane
Hook'D on Access
MS Access MVP

 

[Comp2008]

Thank you very much dhookom. I tried the expression you gave me, and It works perfectly. You made my day. I really appreciate it.

Comp2008