S
SusieS
Table: dbo_tblResults
Fields of Interest: Date, Service
dbo_tblResults is a table of sales lead information originating from a SQL
database and utilized in Access through ODBC. I simply want to generate a
report that shows the number of leads each service has generated BY MONTH.
From the other threads I gathered that I should create a report grouped on
Date, then on Service, and include in the Service group footer an unbound
text box with the control source including an expression that would total
each.
I've gotten as far as the expression :
=DCount("*","dbo_tblResults","[Service]")
This shows me the total number of leads in the table, but not segmented by
service or date. How would I accomplish that?!
Fields of Interest: Date, Service
dbo_tblResults is a table of sales lead information originating from a SQL
database and utilized in Access through ODBC. I simply want to generate a
report that shows the number of leads each service has generated BY MONTH.
From the other threads I gathered that I should create a report grouped on
Date, then on Service, and include in the Service group footer an unbound
text box with the control source including an expression that would total
each.
I've gotten as far as the expression :
=DCount("*","dbo_tblResults","[Service]")
This shows me the total number of leads in the table, but not segmented by
service or date. How would I accomplish that?!