Search results

thanks again Quick reply Pat! Unfortunately have tried that myself - I thought it should be possible but it just doesn't seem to want to rock with me!! If anyone has the chance or Inclination, then just comment (not expecting rewrites!!!) on this amateur effort for me! THanks if able Nic

A real belated thanks!! Many thanks to everyone who helped me on this, particularly Mile-o-phile who took out surely more than a minute or twi to correct my shoddily composed database, a BIG THANK YOU:D I realise that it is unfair to expect people to use their own time to correct others...

Ermmm - its no good, need new brain Sorry about this. Still can't get this to work. I shall try to attach a cut down table and form so you can see what I am trying to do and maybe (after a few slaps with a wet fish to my face) make me see sense!!!

Daft question again Thanks Pat Thats sounds an easier way to do it - though I really get the point now that its not cool to store calculated fields!!! So I went off to try your suggestion, but guess what, I can't even fathom that out!! I understand the principle behing it but do not get your...

OMG! Ah, this is where I see the void that lies between you guys and me!!! It all makes sense (described nicely thanks) but I would never have even contemplated it if you hadn't taught me!!! Thats why people like me, need help from people like you!!!! Cheers Nic :)

Eh? Whats 3rd Normal Form then?? I don't want to get into trouble if I can help it!!! Is this a true entity, or am I being councelled in the way of the masters???!!!!! Nic :D :D :) :confused:

Thanks Thanks everyone Seem to have it working by using an update query as suggested which is run everytime the form is closed (though it actually updates ALL the total scores fields - doubt I can stop that though?) Still can't decide whether (again as suggested) I actually need the value...

hmmm Thanks guys for the prompt reply. I really need to have the value stored in the table as the data from the table is used to produce reports - so calculating the total on the form will not help. As for an update query - would that not require me to "run" it everytime the total is calculated...

Hi there everyone, I hope someone can point out the obvious to me as I have exhausted my limited knowledge of access to perform what I would have thought to be simple task!! I have a form called "scoreform" linked to a table called "scoretable", in this table there are numerous fields that hold...