Search results

Thank you John, that really helped. I have now got the Sum or total displayed in a text box on the main form. However, the new "Total" column still remains even after Visible:No ??? Thanks fro the help. Benn.

Hi guys, Just a quick question and I'm sure it's something basic. I am trying to use the Sum function on a subform. I have done a search and found the answer to my first question, however I'm still having trouble. I have made a text box in the Form Footer of the sub-form. It contains...

Edit: It's all working now, thanks for the help.

Hi guys, I am having a few issues using the iif statments in Access. Basically, I have a store database with one of fields being "Offer". This is a Yes/No data type. I use the label wizard to make labels that will go on my products. The problem I am having is this - If the "Offer" value =...