Name: prec_access.jpg Views: 10 Size: 42.6 KB ID: 21070" class="thumbnail" style="float:CONFIG" />
Guys,
Essentially I have both these queries.
One to show the total number of 'valves' by a certain manufacturer and another to show the certain number of valves that have failed their annual test by a certain manufacturer.
What I want to do it, look the the total number of valves for 'Noneywell' for example, then look at the total number of fails - and return that as a percentage.
Any help will be greatfully recieved.