Search results

It works! As well as the Sum boxes, I had another text box that tried to calculate an average based on the sums. This was pointing to a control, rather than a field. I amended that, and my Sum boxes are now working! Thanks for the replies :)

Thanks Paul, sorry I meant to put - I've tried both the field and the control. Tried it again just now using =SUM(I_Know_Loads_1) and still getting #Error. EDIT: I've also added =SUM text boxes for the other fields (Clinics, Contraception, Viral/Bacterial) to test them and getting #Error on...

Hi, I was hoping someone could please help: I'm trying to create a Sum on my subform in order to caclulate on my main form, but I'm getting #Error on the subform field My Sum field control source is set as: =Sum([txtIknowLoads]) The field I'm trying to Sum is: Name: txtIKnowLoads Control...

Great, that worked a treat, thanks v much :D

Hi, Afraid that doesn't work, I still get "Runtime error 3075: syntax error in query expression" Also, any people without ' in their names, I now get the same error message. :confused:

Hi all, Hope this thread is posted in the right place.... :) Just wanted a bit of help with some Access VBA; I've got a table I'm trying to update via an unbound form. My code falls over when trying to update a record for a person with a ' in their name i.e. O'Neil, O'Mara etc. Does...