Expression Meanings-Hi What Does the following Expression Mean?

**KERRYDEE** · 05-11-2016, 10:17 PM

1. IIf(IsNull([LastName]),IIf(IsNull([FirstName]),[Company],[FirstName]),IIf(IsNull([FirstName]),[LastName],[FirstName] & " " & [LastName]))

2 IsNull([InvoiceID])

Thank you very much for your help.!!!

KerryDee

**orange** · 05-12-2016, 05:30 AM

See Techonthenet

IsNULL()

**KERRYDEE** · 05-12-2016, 04:31 PM

Thank you very much that helped tremendously.

Expression Meanings-Hi What Does the following Expression Mean?

Thread Tools

Expression Meanings-Hi What Does the following Expression Mean?

Similar Threads

The query I want to access is not in the list of Expression Elements in the Expression builder

Multiple relations of 1 table to another with different meanings

Reference result of expression in another expression

Expression builder does not show other query fields to add to an expression.

Expression to complex in query expression (switch)

Posting Permissions