Query

[jbarrum]

I have a query righ not that shows advances and the sum of payments made towards repaying that advance. I also have an expression in the last column of the query that provides me a balance by taking the [advance]-[SumofAdvance]. I would know like to filter the records to only show me those advances that have a balance greater then "0". When I try and appliy this condition to the query it prompts me fora value in the "SumOfPmts" field.

The filed I am trying to filter on is a calclated expression. How can I apply a condition on a field that is a caclulated expression. I think this is why I am having trouble.

[MAF4Fam6]

You should be able to set a criteria in your query on a calculated field name.
In your query's design view, last column field name (calculated field)...are you using >0 in the criteria section?

-RC

[jbarrum]

Yes, that is what I thought, but for some reason when I do that, and run the query, it prompts me for a parameter value refering to the SumOfPmts field.

[jbarrum]

I found the resolution to my problem. I created a brand new query using fields from the original query and then applied my filter and it worked. Hallelujah

Thanks,

JB