Code:
SELECT Date() AS [Last Update], [Qry_Sales Report_Final pre].[Agent Name], IIf([Total Points]=0,9999,IIf([Total Points]<1,[cost],Round(nz([cost]/nz([Total Points],0),0),2))) AS CPS, [Qry_Sales Report_Final pre].[Total Points], [Qry_Sales Report_Final pre].Sold, [Qry_Sales Report_Final pre].Inbound, [Qry_Sales Report_Final pre].Outbound, [Qry_Sales Report_Final pre].[SV Close%], [Qry_Sales Report_Final pre].DISH, [Qry_Sales Report_Final pre].[DISH %], [Qry_Sales Report_Final pre].DHA, [Qry_Sales Report_Final pre].[DHA% (10%)], [Qry_Sales Report_Final pre].Flex, [Qry_Sales Report_Final pre].[Flex% (3%)], [Qry_Sales Report_Final pre].CCA, [Qry_Sales Report_Final pre].[CCA % (95%)], [Qry_Sales Report_Final pre].DVR, [Qry_Sales Report_Final pre].[DVR % (85%)], [Qry_Sales Report_Final pre].DTV, [Qry_Sales Report_Final pre].[DTV % (1%)], [Qry_Sales Report_Final pre].DSL, [Qry_Sales Report_Final pre].[DSL % (4%)], [Qry_Sales Report_Final pre].Cable, [Qry_Sales Report_Final pre].[Cable % (5%)], [Qry_Sales Report_Final pre].HN, [Qry_Sales Report_Final pre].[HN % - (1&1/2%)], [Qry_Sales Report_Final pre].WB, [Qry_Sales Report_Final pre].[WB % - (1%)], [Qry_Sales Report_Final pre].Qwest, [Qry_Sales Report_Final pre].[Qwest % (1%)], [Qry_Sales Report_Final pre].EL, [Qry_Sales Report_Final pre].[EL%], [Qry_Sales Report_Final pre].Cyb, [Qry_Sales Report_Final pre].[Cyb %], [Qry_Sales Report_Final pre].Charter, [Qry_Sales Report_Final pre].[Charter %], [Qry_Sales Report_Final pre].[PF to Collect], [Qry_Sales Report_Final pre].[PF Collected], [Qry_Sales Report_Final pre].[Collected %], [Qry_Sales Report_Final pre].[PF Waived], [Qry_Sales Report_Final pre].[Waived %], [Qry_Sales Report_Final pre].[Alt Phone], [Qry_Sales Report_Final pre].[Alt Phone % (73%)], [Qry_Sales Report_Final pre].[E-mail], [Qry_Sales Report_Final pre].[E-mail % (95%)]
FROM [Qry_Sales Report_Final pre]
ORDER BY [Qry_Sales Report_Final pre].[SV Close%] DESC;