Dcount without a specific query

[gjameson via AccessMonster.com]

I have a report that is run from this criteria :

SELECT Customer.ID, Customer.[Cust Name], Customer.BAN_ROUTE, Customer.
ABREV_BOOK, Customer.CURTAIL_RT, Customer.CC_RT_NBR, Customer.[Mtr #],
Customer.[Mtr Size], Customer.[St Nbr], Customer.[St Name], Customer.[Prem #],
Customer.Status
FROM Customer
WHERE (((Customer.ID)<200000) AND ((Customer.BAN_ROUTE)=[Forms]![Main]!
[cboMaintRoute]) AND ((Customer.Status)<>"I"))
ORDER BY Customer.CURTAIL_RT;


cboMaintRoute is the main element here. There are about 20 different
selections that can be made. I want to total the records in the footer of
each report. I have played with Count, Dcount, and Sum with no luck. How can
this be done?

TIA

Gerald

 

[Duane Hookom]

It doesn't look like you have any numeric fields in your report's record
source that can be summed. If you want to count the records in your record
source, add a text box to the Report Footer section and set its Control
Source to:
=Count(*)

If you have had issues using Sum() or Count(), you may be using the Page
Footer rather than the Report Footer.

 

[gjameson via AccessMonster.com]

Thank you very much. I was using the page footer instead of the report footer.
I also used the =Count(*) .

It doesn't look like you have any numeric fields in your report's record
source that can be summed. If you want to count the records in your record
source, add a text box to the Report Footer section and set its Control
Source to:
=Count(*)

If you have had issues using Sum() or Count(), you may be using the Page
Footer rather than the Report Footer.

I have a report that is run from this criteria :

[quoted text clipped - 15 lines]

Gerald