microsoft access training uk - the iif statement

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training uk - The IIf statement

microsoft access training uk - The IIf statement

resolvedResolved · Low Priority · Version Standard

Ian has attended:
Access Intermediate course

The IIf statement

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

RE: The IIf statement

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.


 

Access tip:

Related tables

When you have related tables such as Customers and their Orders, the Customer table is the Primary table.

Open the Customers table in datasheet view and go to the Home Tab and Records group. Click on the More option and choose Subdatasheet and then click on Subdatasheet again. Now choose the related table (Orders) and click ok.

Now you can click the + symbol by each company to show the related orders.

View all Access hints and tips


Server loaded in 0.08 secs.