Hi Robin,
missing a bracket (or have an extra one since PartnerFirstName does not have spaces or special characters):
Nz([PartnerFirstName)="" --> Nz([PartnerFirstName])=""
comma in wrong place, delimit & with space
""[PartnerFirstName]&" "&[PartnerSurname],
-->
"", [PartnerFirstName] & " " & [PartnerSurname]
and you have an extra parentheses on the end...
Warm Regards,
Crystal
*
(: have an awesome day :)
*
--- On Thu, 7/14/11, Robin Chapple 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
>
>
>
Tidak ada komentar:
Posting Komentar