Count records returned from Query

[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!

 

[tina]

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]

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!

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

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!

 

[waters27863]

Thank you! I was putting the count statement in the page footer rather than
the report footer.

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

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!

 

[tina]

you're welcome

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!

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

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!