count of field

[defautt]

What I need help with is getting the diff. of two fields as a %.

Here's what i have

Equip. Desc.
Work Orders
Tasks

For each Equip. Desc. there are multiple work orders, and task numbers.

I need to get the count of work orders for each equip. and the count of tasks for each equip. Then get the percentage of work orders that are not tasks.

Ex.
Equip. = Falcon Wash
Count of W.O. = 554
Count of Tasks = 449
which means that 18.95% of the total work orders for the Falcon Wash are not tasks.

The fields now do not display the count of, but the ref number for each Work order and Task number.

Any advice or help is greatly appreciated.

I am certainly just starting out on this stuff, so if possible keep it simple for me.

Thank You.

[Frank]

You can use COUNT in the SQL to do that. Are you using ASP-db or this is just a general SQL question?

Frank