my code problem

  • Thread starter Thread starter Sam \(antha\)
  • Start date Start date
S

Sam \(antha\)

I have stared at this (control source) code for a long
time and cannot see the problem. Perhaps someone can help
me.

My test for [framePricing]=1 works successfully, as do
the prior tests. However, I cannot get return for
[framePricing]=2. I am convinced I am not placing
parenthesis properly, but when I change from below I get
the wrong number of arguments error.

Be kind, I am a (still being) self-taught amateur.

Thanks,
Sam

=IIf([frameService]<>3 Or [dogcount]=0,0,
IIf([framepricing]=1,
IIf([frameHSType]=1 And [dogcount]<4,
[PHS1231NetH]*[HSHolidayDays],
IIf([frameHSType]=1 And [dogcount]>3,
[PHS1241NetH]*[HSHolidayDays],
IIf([frameHSType]=2 And [dogcount]<4,
[PHS2431NetH]*[HSHolidayDays],
IIf([frameHSType]=2 And [dogcount]>3,
[PHS2441NetH]*[HSHolidayDays],

IIf([framepricing]=2,
IIf([frameHSType]=1 And [dogcount]<4,
[PHS1232NetH]*[HSHolidayDays],
IIf([frameHSType]=1 And [dogcount]>3,
[PHS1242NetH]*[HSHolidayDays],
IIf([frameHSType]=2 And [dogcount]<4,
[PHS2432NetH]*[HSHolidayDays],
IIf([frameHSType]=2 And [dogcount]>3,
[PHS2442NetH]*[HSHolidayDays])))))))))))
 
Sam (antha) said:
I have stared at this (control source) code for a long
time and cannot see the problem. Perhaps someone can help
me.
Click to expand...

Answered in another newsgroup where you posted this question
independently. That's called "multiposting", and it's generally frowned
on because others don't know what answers have already been given, and
so they duplicate the effort. Also it's harder for you to keep track of
the various replies, and it's harder for later readers of the question,
who may be looking for the same answer, to learn what they need.

In most cases a single, well-chosen newsgroup will do. If your question
really is relevant to more than one newsgroup, the approved technique is
to "crosspost" it instead, by listing multiple newsgroups in the To: or
Newsgroups: line of a single message. If you do that, the message and
any replies will appear in all the listed newsgroups automatically,
which is beneficial to all concerned.
 
Yep, figured that this was not the correct newsgroup when
I got no replies. That's why I apologized in the other.
I don't need any more confusion. LOL
 
Back
Top