A Form A Query and Message Boxes I don't want.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a "open invoice query" with a) sum of applied payments. b)sum of
items * sum of item fees (this is Expr1) and c) Expr1 - sum of applied
payments (this is Expr2).
This works well, but I want to set criteria on Expr 2 so that only invoices
with a nonzero balance appear on my form. This doesn't seem to be working.
As soon as I type in >0, no invoices show.
Also, I do not want criteria parameter boxes to show when I run the query.
Is any of this possible?
 
Try posting the entire SQL view of your query. In the meantime:

This can sometimes be made more transparent by using two queries: one with
Totals turn on that provides the sums (SumOfAppliedPayments, SumOfItemFees, &
SumOfItems), and another (whose source is not a table, but the first query)
that provides the second-level calculations (SumOfItems * SumOfItemFees -
SumOfAppliedPayments).
 
Back
Top