IIF statement

[MEERPAREL]

Hi, need some help

I created in the detailsection of a report an unbound Textbox with
an IIF statement

if field A is empty then print fieldB; if field A is not empty then
print field C
the contents of Field A - B - and C are text

=IIF([fieldA]="";[fieldB];[fieldC]) this wont work in my
Access (in Excel it works)

In the Dutch version I have to write ; instead of ,

What is going wrong?


Thanks in advance for your prompt reply

Best regards Ron

 

[fredg]

Hi, need some help

I created in the detailsection of a report an unbound Textbox with
an IIF statement

if field A is empty then print fieldB; if field A is not empty then
print field C
the contents of Field A - B - and C are text

=IIF([fieldA]="";[fieldB];[fieldC]) this wont work in my
Access (in Excel it works)

In the Dutch version I have to write ; instead of ,

What is going wrong?

Thanks in advance for your prompt reply

Best regards Ron

=IIF(IsNull([fieldA]);[fieldB];[fieldC])

 

[MEERPAREL]

Hi, need some help

I created in the detailsection of a report an unbound Textbox with
an IIF statement

if field A is empty then print fieldB; if field A is not empty then
print field C
the contents of Field A - B - and C are text

=IIF([fieldA]="";[fieldB];[fieldC]) this wont work in my
Access (in Excel it works)

In the Dutch version I have to write ; instead of ,

What is going wrong?

Thanks in advance for your prompt reply

Best regards Ron

=IIF(IsNull([fieldA]);[fieldB];[fieldC])

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail- Hide quoted text -

- Show quoted text -

YESS
thanks alot Fred