microsoft access training uk - The IIf statement

Resolved · Low Priority · Version Standard

The IIf statement

Ian has attended:
Access Intermediate course

by - delegate Ian [1 post] (2008 Jan 11 Fri, 16:09) Reply

Why does Mircosoft Access use IIf for If statements when Excel and other programming languages use if?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 19 Fri	Bloomsbury	5	book now	£219	£235
2003	2008 Dec 24 Wed	Bayswater	0	FULL
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
2003	2009 Jan 14 Wed	Bloomsbury	8	book now	£187	£224
2003	2009 Jan 23 Fri	Bloomsbury	7	book now	£203	£230
2003	2009 Jan 28 Wed	Bayswater	8	book now	£110	£205
Full Schedule: See all 44 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: The IIf statement

by - trainer Pete platinum contributer [803 posts] (2008 Jan 16 Wed, 09:13) Reply

Hi Ian, Thank you for the post, I remember we had a little chuckle about this on the course, so I expected you to post it as a question; Silly answer; I really dont know, I have searched and googled but no answer, it might be that in the way that Excel uses 'D' functions to distinguish those that are used in Database operations so although it is a pure IF function Access developers used an extra I to distinguish it from normal IF functions found in Excel. Hope that helps, best regards Pete.

· Convert a Paper Trail to a DBMS
· Microsoft Access 2007: New Features
· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· Access Database Optimization: First Normal Form

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips

Rate this page: