Search results

Hi mresann Thanks for that. I had tried that but had an = in it and was causing me problems. Tried your solution and works perfectly. Still learning Access. Once again thanks Alrae1

G'Day all, I am new to the forum family so please excuse any ignorance I may have in asking questions the right way. The following at times depending on certain values creates a negative value. WDCCFrm: [qry Areas]![Formation Value]-([qry Areas]![Formation Value]*((100/[qry...