Report on how many times different data inputed in a field?

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

Guest

How to creat a report on how many times different data are inputed in a
field? I have a survey report to creat. Data source is a table where there is
a field containing different data i.e. 1. Mobile Phone 2. PABX and 3. WLL
that people are using. I have prepared a report where in detail section
showing all the three different data in order. Now, in the report footer
line, I want to summarize the information by each specific data stating how
many times the specific data i.e. Mobile Phone and so on have been found in
the field. I tried with many functions, but, it is not giving the accurate
result. I understand my functions are not the right one. So, I am requesting
you guys please help me solve this problem. I know you are more good in
Access programming than me. Please help!

Sazed ([email protected])
 
Sazed,

One approach here would be to group the data in your report. In the
design view of the report, select Sorting & Grouping from the View menu.
Enter the name of the field that contains this data in the
Filed/Expression column of the dialog window, and then in the Properties
at the bottom of the window, enter Yes for Group Footer. This will put
a new section into the design of the report. In this section, put an
unbound textbox with its Control Source property set to...
=Count(*)

Another approuach is to put 3 unbound textboxes into the Report Footer
section of the report, and set their Control Source properties to the
equivalent of this...
=Abs(Sum([NameOfYourField]="Mobile Phone"))
.... and same for PABX and WLL. Replace [NameOfYourField] with the
actual name of the field.
 
Steve,
I m soooooo happy for the help u rendered to me. It is great to have such
person like u around. I wish u all the success in your life.

Thank you a lot!

Sazed

Steve Schapel said:
Sazed,

One approach here would be to group the data in your report. In the
design view of the report, select Sorting & Grouping from the View menu.
Enter the name of the field that contains this data in the
Filed/Expression column of the dialog window, and then in the Properties
at the bottom of the window, enter Yes for Group Footer. This will put
a new section into the design of the report. In this section, put an
unbound textbox with its Control Source property set to...
=Count(*)

Another approuach is to put 3 unbound textboxes into the Report Footer
section of the report, and set their Control Source properties to the
equivalent of this...
=Abs(Sum([NameOfYourField]="Mobile Phone"))
.... and same for PABX and WLL. Replace [NameOfYourField] with the
actual name of the field.

--
Steve Schapel, Microsoft Access MVP

How to creat a report on how many times different data are inputed in a
field? I have a survey report to creat. Data source is a table where there is
a field containing different data i.e. 1. Mobile Phone 2. PABX and 3. WLL
that people are using. I have prepared a report where in detail section
showing all the three different data in order. Now, in the report footer
line, I want to summarize the information by each specific data stating how
many times the specific data i.e. Mobile Phone and so on have been found in
the field. I tried with many functions, but, it is not giving the accurate
result. I understand my functions are not the right one. So, I am requesting
you guys please help me solve this problem. I know you are more good in
Access programming than me. Please help!

Sazed ([email protected])
Click to expand...
Click to expand...
 
Steve,
Thanks soooooooooo much! you are great!
Now I've another request to u. I want to report which date (within "Mobile
Phone", "PABX", & "WLL") in the field is maximum times found. Likewise, which
has been found minimum times and then by average. It should show the name
like if Mobile Phone is inputed maximum time then the result in the unbound
text box next to the the label "Maximum" will show "Mobile Phone". Would u
please help, please!

Sazed

Steve Schapel said:
Sazed,

One approach here would be to group the data in your report. In the
design view of the report, select Sorting & Grouping from the View menu.
Enter the name of the field that contains this data in the
Filed/Expression column of the dialog window, and then in the Properties
at the bottom of the window, enter Yes for Group Footer. This will put
a new section into the design of the report. In this section, put an
unbound textbox with its Control Source property set to...
=Count(*)

Another approuach is to put 3 unbound textboxes into the Report Footer
section of the report, and set their Control Source properties to the
equivalent of this...
=Abs(Sum([NameOfYourField]="Mobile Phone"))
.... and same for PABX and WLL. Replace [NameOfYourField] with the
actual name of the field.

--
Steve Schapel, Microsoft Access MVP

How to creat a report on how many times different data are inputed in a
field? I have a survey report to creat. Data source is a table where there is
a field containing different data i.e. 1. Mobile Phone 2. PABX and 3. WLL
that people are using. I have prepared a report where in detail section
showing all the three different data in order. Now, in the report footer
line, I want to summarize the information by each specific data stating how
many times the specific data i.e. Mobile Phone and so on have been found in
the field. I tried with many functions, but, it is not giving the accurate
result. I understand my functions are not the right one. So, I am requesting
you guys please help me solve this problem. I know you are more good in
Access programming than me. Please help!

Sazed ([email protected])
Click to expand...
Click to expand...
 
My question is the reverse of Sazed. My supervisor would like to see a report
that totals the number of requisitions without duplicating and counting the
same req #.

Vendor 1: In my report the Header # of Reqs (3) which should be 1
Name Req #
John Doe 00-032
Sue Smith 00-032
Garry Clark 00-032

Vendor 2: Req # (3) should be 2
Name Req #
Mary Doe 00-033
Todd Smith 00-032
Sue Clark 00-033

How do I just report on the req# and not have the duplicates per vendor
counted?
Evelyn Williams
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 
Back
Top