Re: Need correct conditional statement language
- From: Cloudbuster <airwitte@xxxxxxxxxxxx(donotspam)>
- Date: Tue, 4 Mar 2008 11:11:05 -0800
Conan,
That last formula you gave me was not quite correct, b/c the query says
there is a syntax error (comma) in the formula. Here's how it looks now
Balance: IIf([Full Payment]>0,[Amt]-[Full Payment],IIf([Full Payment]=0 Or
[Full Payment] Is Null And [Partial Payment]<=0 Or [Partial Payment] Is
Null,[Amt],IIf([Full Payment]=0 Or [Full Payment] Is Null And [Partial
Payment]>0,[Amt]-([Partial Payment]+[AmtOfRecoveryFee],"0"))))
--
Cloudbuster
"Conan Kelly" wrote:
Cloudbuster,.
Balance (column name): IIF ([field name1]>$0.00, [field name2]-[field
name1],IIF [field name]1=$0.00 or [field name] is NULL AND [field
name3]<=$0.00 or [field name3] is NULL, [field name2], IIF [field
name1]=$0.00 or [field name1] is NULL AND [field name3]>$0.00, [field
name2]-([field name3]+[field name4],"you are missing this last
argument--''What if none of the conditions are met?''")
Notice my little note in there at the very end. Replace my note (everything
between and including the double quotes) with a zero or a field name or
calculation or your own message (your own message or any text would require
double quotes).
HTH,
Conan
"Cloudbuster" <Cloudbuster@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:303BBD13-8B4B-4FD2-89D1-72AE618A1EE4@xxxxxxxxxxxxxxxx
I want to make the following into a conditional statement. Please let me
know
exactly how it should look. The basic formula is as follows:
Balance (column name): IIF ([field name1]>$0.00, then [field name2]-[field
name1] OR
IIF [field name]1=$0.00 or NULL AND IIF [field name3]<=$0.00 or NULL, then
[field name2] OR
IIF [field name1]=$0.00 or NULL AND IIF [field name3]>$0.00, then [field
name2]-([field name3]+[field name4])
- Prev by Date: Complex Query?
- Next by Date: Re: Query Table1 to only return results based on 'criteria' within a 2nd table
- Previous by thread: Complex Query?
- Next by thread: Re: copying database from one computer to another
- Index(es):
Relevant Pages
|
