Subquery vs. IIF

  • Thread starter Thread starter tom
  • Start date Start date
T

tom

Apparently a subquery and an iif statement have
overlapping functionality. Which one is better
to use in which situations?
 
IIf is an Access VBA function.

SubQuery is more or less a construct in JET SQL (and other SQL flavours) ...

While in Access Query, you can use the Access VBA IIf and in some cases. you
can use either the SubQuery construct or IIf, I prefer to use SubQuery if
possible to avoid JET having to call the Access VBA function(s) back and
forth ...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculations on Option Group 2
Circumvent "At most one record can be returned by this subquery"error 4
Multiple iif challenge 2
DSum Works Only for First Group 2
Subquery in an aggregate query. 3
Aggregate Function Error 0
Subquery to get Top 5... 2
Variable subquery criteria SQL problems 1

Back
Top