Multiple calculations in one column

[Brook Morris]

Ok folks I'm stumped!

I have seen this before, but for the life of me can't remember how to do it.
I have a safety and health database with a body part query. Within that
query is a column that has numerous body parts listed. I need to be able to
calculate the number of each type of entry (Body part per injury) to forward
to Command staff.
can we do that in the same column and at the end of each data type listed in
that column.

EX:
Single thumb
Single thumb
2
Head
1

Is there any Access hints for this? I am using Access 2000.

Brook

 

[Rick Brandt]

Ok folks I'm stumped!

I have seen this before, but for the life of me can't remember how to
do it. I have a safety and health database with a body part query.
Within that query is a column that has numerous body parts listed. I
need to be able to calculate the number of each type of entry (Body
part per injury) to forward to Command staff.
can we do that in the same column and at the end of each data type
listed in that column.

EX:
Single thumb
Single thumb
2
Head
1

Is there any Access hints for this? I am using Access 2000.

In a query it would look like...

Single Thumb 2
Head 1

That would be accomplished with a totals query...

SELECT BodyPartField, Count(*) As Qty
FROM TableName
GROUP BY BodyPartField

For the vertical layout you described you would just feed the the table to a
report and have the report Group on the BodyPart field and in the group
footer have a TextBox with =Count(*).