Forum home » Delegate support and help forum » Microsoft Access Training and help » ms access training - If statements

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

ms access training - If statements

Resolved · Low Priority · Version Standard

Reply Thu 19 Jul 2007, 15:36Delegate Sin said...

Sin has attended:
Access Intermediate course
Access Advanced course
Access VBA course

If statements

I am trying to set up a statement that does the following:
Column 1 - has data
Column 2 - may or may not have data
Column 3 - is to contain the IFf statement which will check columns 1&2 and if 2 is blank, insert the contents of 1. If not, insert the contents of column 2.

Currently I can get it to insert the contents of either one or 2 at a time but not pick from both.

For upcoming training course dates see: Pricing & availability

Reply Fri 20 Jul 2007, 10:29Trainer Richard said...

RE: If statements

Try

=IIF([field2] is null, [field1],[field2])

Reply Fri 20 Jul 2007, 15:08Delegate Sin said...

RE: If statements

Perfect! Thanks very much.

Access articles

· How To Create A Combo Control On An Access Form
· Access Database Optimization: First Normal Form
· Don't Do It By The Book, Access Your Important Contacts In An Easy To Use Database
· How To Sort And Filter A Table In Access 2010
· Cheating With Access Templates

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy