Kamis, 14 Juli 2011

Re: [MS_AccessPros] Wrong number of arguments - "Woe is me"

 

Hi Robin,

glad you got it :)

Here are the main things to remember :

1. balance brackets and parentheses
2. make sure commas are in the right place
3. delimit & with space
ie: instead of this:
a&b
do this:
a & b

I use NotePad to paste an equation into and break lines at open parentheses ( to find places where parentheses aren't balanced. I do the same thing for commas sometimes too

Access 2010 has better Intellisense and a more robust Expression Builder*. It is easier to write equations and see where things aren't balanced.

* press Ctrl-F2 to invoke the Expression Builder.

Warm Regards,
Crystal

*
(: have an awesome day :)
*

--- On Thu, 7/14/11, Robin Chapple wrote:

>
> Thanks Crystal,
>
> I did not understand your method of presentation but by
> trying all
> possibilities I worked it out.
>
> All is well.
>
> Robin
>
> At 14/07/2011 04:53 PM, you wrote:
>
> >After considerable help from this list I have been
> making reports.
> >
> >Now I have a problem. Access tells me I have the wrong
> number of arguments.
> >
> >=[NameFull] & " " &
> IIf(Nz([PartnerFirstName)="","
> >"[PartnerFirstName]&" "&[PartnerSurname],))
> >
> >What have I missed?
> >
> >Many thanks,
> >
> >Robin Chapple
> >
> >
> >

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar