Query with multiple nested calculations in one column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brook Morris - 12 Jan 2006 13:00 GMT

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.

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

Brook

Reply to this Message

Brook Morris - 12 Jan 2006 13:03 GMT

BTW, the whole point of sending this email was see if we can 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

Brook

>Ok folks I'm stumped!
>
[quoted text clipped - 7 lines]
>
>Brook

Reply to this Message

Brook Morris - 12 Jan 2006 13:23 GMT

Wrong forum sorry

>Ok folks I'm stumped!
>
[quoted text clipped - 7 lines]
>
>Brook

Reply to this Message