How do I set criteria for calculated total fields in a query?

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

Guest

In a Query I created a calculated field of cost#1.33. I than created a filed
using the product of that calculation - a set value. I am trying to use
criteria to limit the query to only those items that return a value greater
than 1. When I just use >1 in the criteria of the expr1: field I get no
matching records when there are severel. If I use no criteria I get negitive
numbers with my possitive ones.
 
Tom,

This might be easier in SQL mode. You should add before the end of your
query,
HAVING [your named expression] > 1. For example, HAVING CalCost > 1, this
should take care of that issue.

Jeff Shanker
 
Back
Top