Recent content by Chrisqld

Thanks Steve, I had thought about the DLookup but was put-off by all the negative comments throughout the forum. HOWEVER persistence pays, all good now with the text box control source =Sum(Abs(RangeFee))*(DLookup("[Cost]","[Fees]","[ID]=1")). Counts the range fee ticks and multiplies by the...

OK. The form is based on the table 'RangeFee' and is used to populate that table. The form works exactly as its was intended ie to add the date, members name and a check box as to the payment (or not) of range fee to the RangeFee table. No data about the total of range fee payments for that day...

I have a test db, very simple and I need to count the number of ticked boxes on the form (Range Fee) and then multiple the result by the cost which is derived from a query . I have attached the test DB. Chris D.