Recent content by Koka_Kola

Yes!! It works!! Thank you!:D

Fitting is a text field, I didn't use an expression builder - this is an ICT project for school which I'm finding particularly difficult (mainly because I don't have a clue how to use access properly!) So I'm mainly basing it on knowledge of excel if functions! I'm not sure if I'm allowed to...

Hi, I've just spent ages trying to get an IF function to work on my form on access and keep getting a '#Name?' error. I'm certain that all of the field names I have used are correct, so I'm not really too sure whats wrong with it. =IF([Fitting]=Yes,"[Carpet Area]*[FittingPrice]+20","0.00")...