Re: QUERY!

Or, if we can get that group by working, he could use the freebie Query 
Management Query.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Peter Vidal" <Peter_Vidal@xxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
02/24/2004 10:19 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Fax to

Subject
Re: QUERY!







"But I need to add IM of both exch(22&JA) and put the value against 
exch22. And
same for 24&JB..."

Then, I do not think that you can do this in one query.  Maybe one with 
the
accumulated values for records that will match the first criteria (22 & 
JA) and
the second with 24 & JB or maybe a pgm (like Rob stated before) is much 
better.

See, I can't accumulate values under one condition and accumulate values 
for a
different condition, both under the same column and using the same query.

The key is that you are under a "conditioned criteria" situation that a 
pgm will
better suite the need.

IMHO,
Peter Vidal
Pall Aeropower Corp.
SR Programmer Analyst
WWW.Pall.com
"My religion consists of a humble admiration of the illimitable superior
spirit who reveals himself in the slight details we are able to perceive
with our frail and feeble mind."
Albert Einstein



_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.