Solved Run-time error '3061'. Too few parameters. Expected 1 (1 Viewer)

[Number11]

I am getting this error when exporting the Query to excel

I have changed this:

New Order Live: IIf([22].[Serial]=[New_Order]=True,"Yes","No")

Results are Yes or No

to

New Order Live: IIf([22].[Serial]=[New_Order]=True,Yes,No)

Results are 0 or -1

Which has now stopped the error, but i really need it to say the Yes or No Results - any ideas?

 

[silentwolf]

Hi,
I think you don't need the =True part.

Maybe


IIf([22].[Serial]=[New_Order],"Yes","No")

 

[Number11]

Hi,
I think you don't need the =True part.

Maybe


IIf([22].[Serial]=[New_Order],"Yes","No")

yep thats sorted it cheers

 

[silentwolf]

Nice