Count records returned from Query

  • Thread starter Thread starter waters27863
  • Start date Start date
W

waters27863

I have a report that gets run each month which shows details of customer
support calls the techs have recieved throughout the month. I would like to
put a count in the footer of the report that shows the number of calls we
recieved for that particular timeframe. I have the report pulling data from
a query, rather than having the report pull the data itself. I am new to all
this, so I'm not sure if the info here will help, but here is the sql
statement from the query I'm trying to pull the report from. (Oh, and I'm
using Access 2003)

SELECT Info.Technician, Info.[Contact Method], Info.[Problem Category],
Info.Date, Info.[Customer Name], Info.Problem, Info.Resolution
FROM Info
WHERE (((Info.Date) Between [Enter beginning date] And [Enter ending date]));

Any help would be apreciated!
 
add an unbound textbox control to the report's ReportFooter section (not the
Page Footer), and set its' ControlSource to count the records in the report,
as

=Count(*)

hth
 
Thank you so much! I was using that control, but was putting it in the page
footer rather than the report footer. That fixed it!

tina said:
add an unbound textbox control to the report's ReportFooter section (not the
Page Footer), and set its' ControlSource to count the records in the report,
as

=Count(*)

hth


waters27863 said:
I have a report that gets run each month which shows details of customer
support calls the techs have recieved throughout the month. I would like to
put a count in the footer of the report that shows the number of calls we
recieved for that particular timeframe. I have the report pulling data from
a query, rather than having the report pull the data itself. I am new to all
this, so I'm not sure if the info here will help, but here is the sql
statement from the query I'm trying to pull the report from. (Oh, and I'm
using Access 2003)

SELECT Info.Technician, Info.[Contact Method], Info.[Problem Category],
Info.Date, Info.[Customer Name], Info.Problem, Info.Resolution
FROM Info
WHERE (((Info.Date) Between [Enter beginning date] And [Enter ending date]));

Any help would be apreciated!
Click to expand...
Click to expand...
 
Thank you! I was putting the count statement in the page footer rather than
the report footer.

tina said:
add an unbound textbox control to the report's ReportFooter section (not the
Page Footer), and set its' ControlSource to count the records in the report,
as

=Count(*)

hth


waters27863 said:
I have a report that gets run each month which shows details of customer
support calls the techs have recieved throughout the month. I would like to
put a count in the footer of the report that shows the number of calls we
recieved for that particular timeframe. I have the report pulling data from
a query, rather than having the report pull the data itself. I am new to all
this, so I'm not sure if the info here will help, but here is the sql
statement from the query I'm trying to pull the report from. (Oh, and I'm
using Access 2003)

SELECT Info.Technician, Info.[Contact Method], Info.[Problem Category],
Info.Date, Info.[Customer Name], Info.Problem, Info.Resolution
FROM Info
WHERE (((Info.Date) Between [Enter beginning date] And [Enter ending date]));

Any help would be apreciated!
Click to expand...
Click to expand...
 
you're welcome :)


waters27863 said:
Thank you so much! I was using that control, but was putting it in the page
footer rather than the report footer. That fixed it!

tina said:
add an unbound textbox control to the report's ReportFooter section (not the
Page Footer), and set its' ControlSource to count the records in the report,
as

=Count(*)

hth


waters27863 said:
I have a report that gets run each month which shows details of customer
support calls the techs have recieved throughout the month. I would
Click to expand...
like
to
put a count in the footer of the report that shows the number of calls we
recieved for that particular timeframe. I have the report pulling
Click to expand...
data
from
a query, rather than having the report pull the data itself. I am new
Click to expand...
to
all
this, so I'm not sure if the info here will help, but here is the sql
statement from the query I'm trying to pull the report from. (Oh, and I'm
using Access 2003)

SELECT Info.Technician, Info.[Contact Method], Info.[Problem Category],
Info.Date, Info.[Customer Name], Info.Problem, Info.Resolution
FROM Info
WHERE (((Info.Date) Between [Enter beginning date] And [Enter ending date]));

Any help would be apreciated!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top