Creating an IF statement in a Database

**thexxvi** · 05-11-2015, 01:50 PM

Good afternoon,

I have a table and need to create an if statement in a field that is dependent on another field. So if Field A shows "yes", then Field B would result in a certain value. If field A shows "no", then Field B would result in a blank.

How can I complete this?

**Bob Fitz** · 05-11-2015, 02:12 PM

IMHO that would make Field B a calculated field and as such it would probably be better not to store this value in a table. Better to calculate the value whenever and where ever it is required.

**JoeM** · 05-11-2015, 02:36 PM

Here is a link on how to use the IIF function in an Access query to do what you want: http://www.techonthenet.com/access/f...vanced/iif.php

**thexxvi** · 05-12-2015, 06:13 AM

Thank you for the responses. I just made the field a calculated field and it is updating that information in the database, but it's not showing the update on the form. For example, I update Field 1 with "Yes" and Field 2 is supposed to show a certain value. That value appears on the database, but is not showing up on the form. Any ideas why the value wouldn't show up on the form?

**JoeM** · 05-12-2015, 06:22 AM

You still haven't answered my question.
Exactly WHERE have you placed this calculated field?
On the Form itself? In the underlying Query? In the Table?
A database is made up of all these objects, so saying the "database" does not really narrow it down.

**thexxvi** · 05-12-2015, 06:32 AM

I didn't see a question in your initial post JoeM, but to answer your question, it's in the table.

I figured it out though. I set the field up as a calculated field in the table and placed a refresh macro on the form and it works perfectly.

Thanks everyone.

**JoeM** · 05-12-2015, 07:10 AM

Glad you got it figured out.
I would recommend against putting calculated fields in tables. While Access does now allow that functionality, almost all database programs (like SQL, Oracle, etc) do not. So if you ever needed to convert your database to a "real" database back-end, you would have some issues.

It is generally recommended to do all those calculations in a query, and then use the query as the Data Source of your Form (instead of the Table).

Creating an IF statement in a Database

Thread Tools

Creating an IF statement in a Database

Similar Threads

Problem: Creating an IIF statement in a BETWEEN statement for dates

Creating an IF statement within a Form

Creating an FAQ database

Creating If Statement in form

Creating a database

Posting Permissions