Enquiry conversion

[aparnawangu]

Hi All,
I want to generate a query in access where i want to calculate the percentage of conversion from the total nos.
Foreg the total enquiries are 100 out of which 30 were cold so we dont require that only hot and warm enquiry conversion percentage i require.

Pls help

Regards
Aparna

 

[Ranman256]

Create Q1 to sum your data.
Then make Q2, that uses Q1 and your data table to calculate the percents.