select unitofmeasure
from tblmanufacturers
where mfr_id =
select sum(caseamt) as caseamt, sum(incomeamt) as incomeamt, sum(weightAmt) as weightAmt
from qmd_opportunities
where statecode <> 'R'
select 0 as rowNumber, *
from qmd_opportunities
order by #url.orderby#
select *
from qmd_opportunities
where rownumber >= #_startRow#
and rownumber <= #_endRow#
Page #url.pg# of #_pageCount#
#numberformat(_totalOriginalRecords,"9,999")# Opportunities
Total Pounds: #numberformat(qryPlanStats.weightAmt,"9,999")#
Total Cases: #numberformat(qryPlanStats.caseamt,"9,999")#
Total Dollars: $#numberformat(qryPlanStats.incomeamt,"9,999")#