adding a query to an exiting report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that provides the details from a query selected by date
range. I want to sort the results by type, then I want to know how to add
the counts of each type. I know that this is a basic Acess 2000 thing- But I
am a new user.
 
Kelly:

One alternative is to use the Sorting and Grouping option on the View menu
to both sort your results by Type and provide a count by Type using a group
footer. In the Sorting and Grouping dialog box, select the Type field and
then select how you would like to sort it, ascending or descending. Below
that, under Group Properties select Yes for Group Footer. A Type group
footer will now appear on your report. If you use a textbox in the group
footer, you can set its Control Source property to Count(*) to count the
records for each Type. For example:

=Count(*)

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I have a report that provides the details from a query selected by date
range. I want to sort the results by type, then I want to know how to add
the counts of each type. I know that this is a basic Acess 2000 thing- But
I
am a new user.
 
Daivd-
Thank you that worked for my first type of record. I was wondering if you
could tell me how to do the same thing for a second (and independant) type.
I have call reasons and call status that I need counts of t o appear on this
report. I was able to add the group footer for call status to give me that
within the report. Is there a way on the report footer to generate those
other counts? Or do I need to create an additonal query and add a subreport?
Thanks!
Kelly
 
Kelly:

If your question is whether you can get a total count for all groups in the
report footer, the answer is yes. You would use the same methodology of
setting the Control Source property of a text box in the report footer.

If I did not interpret your question correctly, please let me know.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Daivd-
Thank you that worked for my first type of record. I was wondering if you
could tell me how to do the same thing for a second (and independant) type.
I have call reasons and call status that I need counts of t o appear on this
report. I was able to add the group footer for call status to give me that
within the report. Is there a way on the report footer to generate those
other counts? Or do I need to create an additonal query and add a subreport?
Thanks!
Kelly
 
David-
Sorry I am not very good an explaining myself. I have records that look like
# Status Reason Tech
1 S1 R2 T2
2 S1 R1 T1
3 S1 R2 T1
4 S2 R1 T2
5 S2 R3 T1

You showed me how to add counts for the status within the report.
I am trying to determine how to do counts for the reasons and techs (these
are selected from a list box) To get results like
Reasons : R1 2 R2 2 R3 1
Techs: T1 3 T2 2
Any help would be greatly appreciated.
 
Back
Top