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

Sazed · External Since: Dec 31, 2005 Posts: 3

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 (impatientheart@hotmail.com)

Steve Schapel · External Since: Jan 21, 2004 Posts: 2105

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

Sazed wrote:
> 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 (impatientheart@hotmail.com)

Sazed · External Since: Dec 31, 2005 Posts: 3

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" wrote:

> 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
>
>
> Sazed wrote:
> > 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 (impatientheart@hotmail.com)
>

Sazed · External Since: Dec 31, 2005 Posts: 3

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" wrote:

> 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
>
>
> Sazed wrote:
> > 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 (impatientheart@hotmail.com)
>

Evelyn Williams · External Since: Sep 23, 2009 Posts: 2

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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Sazed" wrote:

> 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 (impatientheart@hotmail.com)