Function containing the wrong number of arguments

[Noel]

I am trying to enter this expression in my query and I keep getting "The
expression you entered as a function containing the wrong number of
arguments." I am a newbie to writing expressions so I am not for sure what I
am doing wrong.

Error: IIf([Qtrs to Purchase
Check]=[tblServicePurchase.Qtrs_to_Purchase],"Correct","Mismatch",
(IIf([Qtrs_to_Purchase Check]=[NumberofRegularCredits],"Correct","Mismatch",
(IIf([Qtrs_to_Purchase Check]=[BuyBackCreditQuarters],"Correct","Mismatch")))

Thanks

 

[Ken Snell \(MVP\)]

Error: IIf([Qtrs to Purchase
Check]=[tblServicePurchase].[Qtrs_to_Purchase],"Correct",
IIf([Qtrs_to_Purchase Check]=[NumberofRegularCredits],"Correct",
IIf([Qtrs_to_Purchase Check]=[BuyBackCreditQuarters],"Correct","Mismatch")))

 

[KARL DEWEY]

You have three IIF statements but did not nest them.
I think this is what you want --
Error:
IIf([Qtrs to Purchase Check]=[tblServicePurchase.Qtrs_to_Purchase] OR
[Qtrs_to_Purchase Check]=[NumberofRegularCredits] OR
[Qtrs_to_Purchase Check]=[BuyBackCreditQuarters],"Correct","Mismatch")

 

[Noel]

This worked but I am now getting a box to Enter Paramenter Value for Qtrs to
Purchase. I have checked the spelling and it is included in the table.

Error: IIf([Qtrs to Purchase
Check]=[tblServicePurchase].[Qtrs_to_Purchase],"Correct",
IIf([Qtrs_to_Purchase Check]=[NumberofRegularCredits],"Correct",
IIf([Qtrs_to_Purchase Check]=[BuyBackCreditQuarters],"Correct","Mismatch")))

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

I am trying to enter this expression in my query and I keep getting "The
expression you entered as a function containing the wrong number of
arguments." I am a newbie to writing expressions so I am not for sure what
I
am doing wrong.

Error: IIf([Qtrs to Purchase
Check]=[tblServicePurchase.Qtrs_to_Purchase],"Correct","Mismatch",
(IIf([Qtrs_to_Purchase
Check]=[NumberofRegularCredits],"Correct","Mismatch",
(IIf([Qtrs_to_Purchase
Check]=[BuyBackCreditQuarters],"Correct","Mismatch")))

Thanks

 

[Ken Snell \(MVP\)]

Try this then:

Error: IIf([Qtrs to Purchase
Check]=[Qtrs_to_Purchase],"Correct",
IIf([Qtrs_to_Purchase Check]=[NumberofRegularCredits],"Correct",
IIf([Qtrs_to_Purchase Check]=[BuyBackCreditQuarters],"Correct","Mismatch")))

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

This worked but I am now getting a box to Enter Paramenter Value for Qtrs
to
Purchase. I have checked the spelling and it is included in the table.

Error: IIf([Qtrs to Purchase
Check]=[tblServicePurchase].[Qtrs_to_Purchase],"Correct",
IIf([Qtrs_to_Purchase Check]=[NumberofRegularCredits],"Correct",
IIf([Qtrs_to_Purchase
Check]=[BuyBackCreditQuarters],"Correct","Mismatch")))

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

I am trying to enter this expression in my query and I keep getting "The
expression you entered as a function containing the wrong number of
arguments." I am a newbie to writing expressions so I am not for sure
what
I
am doing wrong.

Error: IIf([Qtrs to Purchase
Check]=[tblServicePurchase.Qtrs_to_Purchase],"Correct","Mismatch",
(IIf([Qtrs_to_Purchase
Check]=[NumberofRegularCredits],"Correct","Mismatch",
(IIf([Qtrs_to_Purchase
Check]=[BuyBackCreditQuarters],"Correct","Mismatch")))

Thanks

 

[KARL DEWEY]

Need to take the wrap out of this --
Error: IIf([Qtrs to Purchase
Check]=[Qtrs_to_Purchase],"Correct",
to this --
Error: IIf([Qtrs to Purchase Check]= [Qtrs_to_Purchase],"Correct",

--
KARL DEWEY
Build a little - Test a little

Try this then:

Error: IIf([Qtrs to Purchase
Check]=[Qtrs_to_Purchase],"Correct",
IIf([Qtrs_to_Purchase Check]=[NumberofRegularCredits],"Correct",
IIf([Qtrs_to_Purchase Check]=[BuyBackCreditQuarters],"Correct","Mismatch")))

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

This worked but I am now getting a box to Enter Paramenter Value for Qtrs
to
Purchase. I have checked the spelling and it is included in the table.

Error: IIf([Qtrs to Purchase
Check]=[tblServicePurchase].[Qtrs_to_Purchase],"Correct",
IIf([Qtrs_to_Purchase Check]=[NumberofRegularCredits],"Correct",
IIf([Qtrs_to_Purchase
Check]=[BuyBackCreditQuarters],"Correct","Mismatch")))

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/



I am trying to enter this expression in my query and I keep getting "The
expression you entered as a function containing the wrong number of
arguments." I am a newbie to writing expressions so I am not for sure
what
I
am doing wrong.

Error: IIf([Qtrs to Purchase
Check]=[tblServicePurchase.Qtrs_to_Purchase],"Correct","Mismatch",
(IIf([Qtrs_to_Purchase
Check]=[NumberofRegularCredits],"Correct","Mismatch",
(IIf([Qtrs_to_Purchase
Check]=[BuyBackCreditQuarters],"Correct","Mismatch")))

Thanks