I have a table A with data and want to fill another table B with data based
on certain conditions in the first table.
If Field A.Author has a value put A.Author and A.Date in feild B.Author, but
if field A.Autor2 has a value put it and and A.Date in field B.Author instead.
How do i do this?
There is one more condition I have to check in both cases: Put parantheses
round the result if it is 'Y' like this
S_Autor: IIf([A].[Parantheses]='Y';'(' & [A.Author] & [A.Date] &
')';[A.Author] & [A.Date])
I tried to use IIF inside another IIF but it did not work.
--
Thank you.