I have a query named qryTotalNow and it is a SUM query:
SELECT Sum(VisitDetails.[Qty]*[Cost]) AS Total
FROM Visits INNER JOIN VisitDetails ON Visits.VisitID = VisitDetails.VisitID
HAVING (((Visits.tmpPayNow)=Yes));
The textbox in my form has its control source set to...