Count records in Table

  • Thread starter Thread starter Murray
  • Start date Start date
M

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
 
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
Click to expand...

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)
 
Back
Top