Code:
SELECT tblBatt.BatID, qryWattsSum.SumOfTTLWatts AS TTLW, tblBatteryList.BatName, tblBatteryList.BatVolt, tblBatteryList.BatAmp, (([BatAmp]*[BattCnt])/2)-100 AS MaxBatAmp, [Amphr]-40 AS MaxBatAmpCharge, ([Batvolt]*[battcnt])/2 AS BatVoltAvail, [TTLW]/[BatVoltAvail] AS Amphr, Round(((([BatAmp]*[BattCnt])/2)-100)/([TTLW]/[BatVoltAvail]),2) AS totalhrs, Round(((([BatAmp]*[BattCnt])/2)-60)/([TTLW]/[BatVoltAvail]),2) AS totalCGRhrs, tblBatt.BattCnt, [totalCGRhrs]-[totalhrs] AS BatMinutes, [Forms]![FrmInput]![NumHrs] AS nohrs
FROM tblBatt, tblBatteryList, qryWattsSum
WHERE (((tblBatteryList.BatVolt)<>6) AND (((([BatAmp]*[BattCnt])/2)-100)>0) AND ((tblBatt.BattCnt)<16));
This pulls it into the query. When the report opens nohrs is blank.