Dcount without a specific query

  • Thread starter Thread starter gjameson via AccessMonster.com
  • Start date Start date
G

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
 
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.
 
Thank you very much. I was using the page footer instead of the report footer.
I also used the =Count(*) .

Duane said:
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 :
Click to expand...
[quoted text clipped - 15 lines]
Gerald
Click to expand...
Click to expand...
 
Back
Top