Nested IF or IIF Formula Help

[RainLover]

You could do that.

It is not called "conditional formatting"

Conditional formatting is where you change a colour etc based upon the value of a Text Box. If Greater then 20 then Red else Green.

 

[MelonFuel]

My Code now.

On Main Form - =[qryTX4740 subform].[Form]![Dsum]

On Subform - =DSum("TX4740Qty","qryTX4740","[TX4740Description]<>'Basic'")

Basically the code partly works it removes Basic out of the quantity total which is what i want but when i enter the data further down it adds that up and i dont want that to happen.

Thanks

 

[RainLover]

You need to post your Database.

Create a new DB and import only those Tables, queries and Forms to which this question relates.

Do a Compact and Repair then zip.

It should fit. See the FAQs if you are having problems.

Also post a Pic of your relationships. That may also help.