Re: Question about IIF in SQL query
From: dchow (dchow_at_hotmail.com)
Date: 02/06/04
- Next message: Mike: "Re: sub directories"
- Previous message: Jim Rech: "Re: Consolidate User Input"
- In reply to: Bob Phillips: "Re: Question about IIF in SQL query"
- Next in thread: Bob Phillips: "Re: Question about IIF in SQL query"
- Reply: Bob Phillips: "Re: Question about IIF in SQL query"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 06 Feb 2004 14:11:29 -0800
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"
<bob.phillips@notheretiscali.co.uk> wrote:
>Not AFAIK. Why don't you return DOCTYPE and DOCAMT and test DOCTYPE in Excel
>and negate DOCAMT if ="RET".
- Next message: Mike: "Re: sub directories"
- Previous message: Jim Rech: "Re: Consolidate User Input"
- In reply to: Bob Phillips: "Re: Question about IIF in SQL query"
- Next in thread: Bob Phillips: "Re: Question about IIF in SQL query"
- Reply: Bob Phillips: "Re: Question about IIF in SQL query"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
