Microsoft Access IIF Function in a Query

This video tutorial is clear and simple to follow and explains the IIF function well (in it’s simpliest form).

Users who are normally familiar with Microsoft Excel’s IF function will be able to relate to this funtion as it is the same!

The only aspect you will need to know of course is how to create a calculation in a query which is demonstrated quickly in this video but if want to know more about how to calculate in a query and use some of the other tools namely, the Expression Builder to look up other functions and nest functions then take a look at one of my articles www.about-access-databases.com/formula-query.html.

This entry was posted in MS Access, Queries, Utilities and tagged , , , , , , , , . Bookmark the permalink.

5 Responses to Microsoft Access IIF Function in a Query

  1. early childhood education says:

    You really make it appear really easy along with your presentation however I to find this topic to be really one thing which I feel I would never understand. It sort of feels too complex and very extensive for me. I am having a look ahead to your next publish, I will attempt to get the cling of it!

  2. I’d should test with you here. Which is not something I usually do! I get pleasure from studying a put up that may make people think. Also, thanks for permitting me to comment!

  3. Cialis says:

    There are some fascinating cut-off dates in this article however I don’t know if I see all of them center to heart. There’s some validity but I will take hold opinion until I look into it further. Good article , thanks and we wish extra! Added to FeedBurner as effectively

  4. propecia says:

    Oh my goodness! a tremendous article dude. Thanks However I am experiencing subject with ur rss . Don’t know why Unable to subscribe to it. Is there anyone getting identical rss problem? Anyone who knows kindly respond. Thnkx

  5. Thanks for some quality points there. I am kind of new to online , so I printed this off to put in my file, any better way to go about keeping track of it then printing?

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Confirm you are human.