G
Guest
I'm trying to create a query for my library database that will return
[Organizations]![Abbrev] when [Authors]![AuthurNum] is null and otherwise
return [Authors]![FirstName] & " " & [Authors]![LastName]. I've tried every
combination with parentheses and commas and spaces, but I keep getting error
messages in the query grid; or when I go to the table view, I get #Error.
How can I fix this?
By:
IIf(IsNull[Books]![AuthorID],[Organizations]![Abbrev],[Authors]![FirstName] &
" " & [Authors]![LastName])
[Organizations]![Abbrev] when [Authors]![AuthurNum] is null and otherwise
return [Authors]![FirstName] & " " & [Authors]![LastName]. I've tried every
combination with parentheses and commas and spaces, but I keep getting error
messages in the query grid; or when I go to the table view, I get #Error.
How can I fix this?
By:
IIf(IsNull[Books]![AuthorID],[Organizations]![Abbrev],[Authors]![FirstName] &
" " & [Authors]![LastName])