Counting # of occurances in a report meeting many different criter

[Guest]

I am having a little trouble. I have a database set up about a football
game. Each record is an individual play in a football game. I have a query
that seperates all of the pass plays. From this query I have a report and on
the report I have a diagram of a football field. The field is broken down
into different pass zones (ex. "B 1/3", "M 1/3", "F 1/3") within each of
these zones I would like to come up with calculations that count the number
of times that the field passresult = "comp", "inc", "int") This would mean 3
different calculations in each of the 3 different field zones. One for
completions, one for incompletions etc...

I hope this is enough information to work with. I really apprciate your help.

Fipp

 

[Guest]

I may be able to make this more simple. In a report how do I count the total
number of times thatthe following occours:
passzone = "B 1/3"
and
passresult = "comp"

both these fields are text fields. I hope that may make it a little simpler

 

[Guest]

Hi -

On the query that is the source for your report, I think it might be helpful
to create a column with a function that will give the results: ["B 1/3", "M
1/3", "F 1/3"] based upon the yard location. Let's call it "FieldSection",
for example.

Example: FieldSection: IIF([StartingYardLoc]<33,"B
1/3",IIF([StartingYardLoc]>66,"F 1/3","M 1/3"))



Then, in the report, you can use this field for an "outer level" of
grouping, and use "passresult" as a group below that. Then you can use the
normal "count" functions in the footer for "passresult" to get your results
for each possible "passresult" value.

You'll have to come up with another function column in the query to sort the
records so that "M 1/3" comes between "B" and "F".

Hope this helps,

Phil Freihofner

 

[Guest]

Phil I appreciate your response. My problem may be a little more complex then
I explained. The field "passzone" is actually refering to a specific area on
the field based off of the route that was run in relationship to the line of
scrimmage. It is not based on a yardage marker. This field is already entered
into the datbase. This field also contains 23 possibilities I listed 3 of
them ("B 1/3", "M 1/3", "F 1/3") for the demonstration. I have a chart
graphed out in a report and there are 23 seperate boxes. I wanted to put the
results of the # of compleations, # of incompleations, interceptions, etc...
into the boxes that they belong in, in order to give a graphical
representation of what was happening.

I guess I am still trying to find out how to count the # of occurances the
follwing event occours:
[passzone] = "B 1/3" ([passzone] is a text field)
[pres] = "comp" ([pres] is a text field)

 

[Guest]

I tried the following and I am getting an error message?

=DCount("[id]","All Pass","[pres] = 'com'" & "[passzone] = 'B 1/3'")

 

[John Spencer]

=DCount("[id]","All Pass","[pres] = 'com' and [passzone] = 'B 1/3'")

I tried the following and I am getting an error message?

=DCount("[id]","All Pass","[pres] = 'com'" & "[passzone] = 'B 1/3'")

Phil I appreciate your response. My problem may be a little more complex
then
I explained. The field "passzone" is actually refering to a specific area
on
the field based off of the route that was run in relationship to the line
of
scrimmage. It is not based on a yardage marker. This field is already
entered
into the datbase. This field also contains 23 possibilities I listed 3 of
them ("B 1/3", "M 1/3", "F 1/3") for the demonstration. I have a chart
graphed out in a report and there are 23 seperate boxes. I wanted to put
the
results of the # of compleations, # of incompleations, interceptions,
etc...
into the boxes that they belong in, in order to give a graphical
representation of what was happening.

I guess I am still trying to find out how to count the # of occurances
the
follwing event occours:
[passzone] = "B 1/3" ([passzone] is a text field)
[pres] = "comp" ([pres] is a text field)