Okay, the other poster pointed out though that even if you can't use IIF,
there is always another way, DECODe for instance.

Is it Access you are querying?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"dchow" wrote in message
...
I can't do that because what I was doing was to get a total amount for
each customer. If I did what you suggested I would easily fill all
65536 rows. If there is no way I have to do it in 2 queries, one for
iinvoice and one for return.
I thought if this could be done in Access why not Excel.

On Fri, 6 Feb 2004 20:29:37 -0000, "Bob Phillips"
wrote:

Not AFAIK. Why don't you return DOCTYPE and DOCAMT and test DOCTYPE in
Excel
and negate DOCAMT if ="RET".