Ignore certain values

[PeteB]

I need an expression which, on a report, will sum the values in a currency field but ignores values which when previously entered have been marked in some way (e.g. placed in parenthesis or asterisked perhaps when entered):-
What would be the best means of marking the entries to be ignored?
What would be the sum expression?
Would appreciate help with this.

 

[Ranman256]

Do this in the query, an IIF statement to determine if its to be added.

IIF(instr([field],"(")>0,[field],0)

 

[PeteB]

Thanks Ranman256. I will give it a go.