Counting Text in record sets and displaying on a Report

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

Guest

Hi,

I am trying to count the number of visits in a report. The field name is
[VisitType] and I have several types of visits recorded. My form displays all
visits and counts how many there are. I need to then count how many are "Ad
Hoc" visits, How many are "Investigations" and how many are "Flash" visits.
My code that does not work is as follows:

=Count([VisitType]="Flash")
or
=[VisitType].Count("Flash")

Can someone please show me the light?
 
Hi,

I am still getting an error message saying that the expression is typed
incorrectly or to complicated to be evaluated,

Any thoughts?

Ofer Cohen said:
Sorry I missed one thing

=Sum(Abs([VisitType]="Flash"))

--
Good Luck
BS"D


Jurrasicway said:
Hi,

I am trying to count the number of visits in a report. The field name is
[VisitType] and I have several types of visits recorded. My form displays all
visits and counts how many there are. I need to then count how many are "Ad
Hoc" visits, How many are "Investigations" and how many are "Flash" visits.
My code that does not work is as follows:

=Count([VisitType]="Flash")
or
=[VisitType].Count("Flash")

Can someone please show me the light?
 
Where did you located the field that display the count? Is it on the form
footer?

The "VisitType" is the name of the field in the table? It should be.

The field that contain that formula shouldn't be name "VisitType", if that
the case change the name of the field

--
Good Luck
BS"D


Jurrasicway said:
Hi,

I am still getting an error message saying that the expression is typed
incorrectly or to complicated to be evaluated,

Any thoughts?

Ofer Cohen said:
Sorry I missed one thing

=Sum(Abs([VisitType]="Flash"))

--
Good Luck
BS"D


Jurrasicway said:
Hi,

I am trying to count the number of visits in a report. The field name is
[VisitType] and I have several types of visits recorded. My form displays all
visits and counts how many there are. I need to then count how many are "Ad
Hoc" visits, How many are "Investigations" and how many are "Flash" visits.
My code that does not work is as follows:

=Count([VisitType]="Flash")
or
=[VisitType].Count("Flash")

Can someone please show me the light?
 
"VisitType" is the name of the field that stores four types of text to
identify the sort of visit conducted. The text is "Full", "Flash", "Ad Hoc"
and "Banking Investigation". What I need to do is on the first page of the
report (The report header) have a summary of how many visits of each kind
were made. I am using text boxes as follows

Flash Visits 28
Full Visits 5
Ad Hoc Visits 3
Banking Investigations 2

The code that I am struggling with is the code that calculates the number of
visits for each text type.

Ofer Cohen said:
Where did you located the field that display the count? Is it on the form
footer?

The "VisitType" is the name of the field in the table? It should be.

The field that contain that formula shouldn't be name "VisitType", if that
the case change the name of the field

--
Good Luck
BS"D


Jurrasicway said:
Hi,

I am still getting an error message saying that the expression is typed
incorrectly or to complicated to be evaluated,

Any thoughts?

Ofer Cohen said:
Sorry I missed one thing

=Sum(Abs([VisitType]="Flash"))

--
Good Luck
BS"D


:

Hi,

I am trying to count the number of visits in a report. The field name is
[VisitType] and I have several types of visits recorded. My form displays all
visits and counts how many there are. I need to then count how many are "Ad
Hoc" visits, How many are "Investigations" and how many are "Flash" visits.
My code that does not work is as follows:

=Count([VisitType]="Flash")
or
=[VisitType].Count("Flash")

Can someone please show me the light?
 
Can you post the expression you have in the text box in the report header
that should display the count?

Note: try not to create a text box in the report that named "VisitType"

--
Good Luck
BS"D


Jurrasicway said:
"VisitType" is the name of the field that stores four types of text to
identify the sort of visit conducted. The text is "Full", "Flash", "Ad Hoc"
and "Banking Investigation". What I need to do is on the first page of the
report (The report header) have a summary of how many visits of each kind
were made. I am using text boxes as follows

Flash Visits 28
Full Visits 5
Ad Hoc Visits 3
Banking Investigations 2

The code that I am struggling with is the code that calculates the number of
visits for each text type.

Ofer Cohen said:
Where did you located the field that display the count? Is it on the form
footer?

The "VisitType" is the name of the field in the table? It should be.

The field that contain that formula shouldn't be name "VisitType", if that
the case change the name of the field

--
Good Luck
BS"D


Jurrasicway said:
Hi,

I am still getting an error message saying that the expression is typed
incorrectly or to complicated to be evaluated,

Any thoughts?

:

Sorry I missed one thing

=Sum(Abs([VisitType]="Flash"))

--
Good Luck
BS"D


:

Hi,

I am trying to count the number of visits in a report. The field name is
[VisitType] and I have several types of visits recorded. My form displays all
visits and counts how many there are. I need to then count how many are "Ad
Hoc" visits, How many are "Investigations" and how many are "Flash" visits.
My code that does not work is as follows:

=Count([VisitType]="Flash")
or
=[VisitType].Count("Flash")

Can someone please show me the light?
 
Back
Top