Count records in Table

[Murray]

Hi All
I have a table that records if a job is "Alive", "Won", "Lost", or
"Cancelled". I have been asked to get this data to work out a Strike rate -
Wins divided by (Won + lost + Cancelled) What is the easiest way to get this
data onto a form? or how do I get a query to return just the values.
Thanks

 

[k]

test

 

[John W. Vinson]

Hi All
I have a table that records if a job is "Alive", "Won", "Lost", or
"Cancelled". I have been asked to get this data to work out a Strike rate -
Wins divided by (Won + lost + Cancelled) What is the easiest way to get this
data onto a form? or how do I get a query to return just the values.
Thanks

Do a Totals query. Create a Query based on the table; select its primary key
and this field. Make it a Totals query by clicking the Greek Sigma icon;
group by this field and select Count for the primary key field.

You can calculate Strike by basing a second query on this query with an
expression like

Strike: CountofWon / (CountOfAlive + CountOfLost + CountOfCancelled)