Hi there!

Thanks so much to Giorgio and Michael who replied to my posting yesterday.  
I was given an excellent suggestion yesterday on how to streamline my
queries and was given the following suggestion to run the following 6 queries
in my code:

Update tblFinalData
               SET GSTRatio = IIF(IsNull([GSTRation]),0,GSTRatio), _
               HSTRatio = IIF(IsNull(HSTRatio),0,HSTRatio), _
               QSTRatio = IIF(IsNull(QSTRatio),0,QSTRatio), _
               Wildcard1 = IIF(IsNull(Wildcard1),"Empty",Wildcard1), _
               Wildcard2 = IIF(IsNull(Wildcard2),"Empty",Wildcard2), _
               Wildcard3 = IIf(IsNull(Wildcard3), "Empty", Wildcard3)

However, I get an "Expected End of Statement" error with the comma before
the line continuation character being highlighted in the second row of this
code.  Am I missing a bracket somewhere or a comma or are there too many
commas?  I've tried this with and without the line continuation character and
it still doesn't seem to work.

Thanks!

JR