Using a Query Sum in criteria

[chris990]

Hi guys,
I have a newbie question here.

I have a sum in my query, which sums the # of particular units, and want to compare it to a MinimumLevel field. I can get the query to display the Sum and the MinLevel fields, but I can't get them to compare each other and only display the correct results...!

I want to only show records where the SumofQuantity < MinLevel . (The reason I need the sum is because a unit has different lot numbers and have a record for each lot number)

How do I make the correct criteria ??

Hopefully this makes sense. Thanks

 

[chris990]

Nevermind, I got it...

Was overcomplicating things.... < MinLevel right under the Quantity thing worked just fine.