calc field

[nashr1928]

I am using access 2003 and using xp-pro for an o/s. I have a form that has a field call total income. I total the income from a column named Total cost. I use =Sum([Total Cost]). This works perfect but would like to filter it. I have another column named Paid and it is a yes/no source. I would like to add the yes to the above calculation so the Sum only reflects the records that are marked as paid with the check mark. Any idea's??

[June7]

Could filter the form's RecordSet to exclude the No records.

Or try:
Sum(IIf([Paid]=True,[Total Cost],0))

[nashr1928]

Is there an expression that I can put directly in the text field instead of code??

[June7]

Try that same expression in ControlSource of textbox in form footer. I don't have any forms that require aggregate calcs but think I have seen that work for others.

[nashr1928]

I tried this and in the text field I get #Name? instead of a number

[June7]

That usually means Access can't find one or more of the references in the expression. Are those fields in the form's RecordSource? Are those the actual correct spellings for the names?

[nashr1928]

Sum(IIf([Paid]=True,[Total Cost],0))I checked the sources on the table and the names are good. I'm not sure what else it could be......

[June7]

An expression in ControlSource must have = sign. Lack of will also cause that error. Without it, is just a string of text that Access can't understand.

[nashr1928]

Gee's. Yeah I forgot that. I put =Sum and it works perfect. Thanks so much for your help in solving this. Rick