In doing the homework from Lesson 9, I put 2 unbound fields on the report and used IIF statements as the Control Source for IsPaid and IsQuote, respectively. (I even got the nested IIFs right.) Is this way ok, or is it better if the IIFs are in the Query?
Scott Axton
@Reply 4 years ago
The short answer is - if it works and the results are correct, that way is OK.
It's been quite some time since I took E10 and for Richard even longer since he recorded it. So I don't recall the homework.
In Access, there is often multiple ways of accomplishing the same task. One way is not necessarily "more right" than the other.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 10.