access training london in - If, function

The UK's most regular instructor-led training courses.
Training information: access training london in · Courses in microsoft access · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

If, function

Jonathan has attended:
Access Intermediate course

by - delegate Jonathan [2 posts] (2007 May 31 Thu, 14:45) Reply

How do I use the If function in Access?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: If, function

by - trainer Richard platinum contributer [818 posts] (2007 Jun 1 Fri, 09:41) Reply

The IF function in access works the same as in Excel, however the name of the function is IIF. Also, instead of evaluating a cell, you would be evaluating a field name.

Look in the help section for IIF FUNCTION for all the fine details.

· Want to Become the Office Hero? MS Project Training Could be the Answer
· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· How to Find a Third-Party Venue for Microsoft Access Training
· Microsoft Access Beginners' Training: Getting to Grips with Databases
· Quick Access Database Courses: A 10 Step Lesson in Encrypting and Decrypting an Access Database

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips