Thank you
From: "wrmosca@comcast.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, August 12, 2015 5:43 PM
Subject: [MS_AccessPros] Re: Populate a field according to value of two other fields.
You can do this in a query like this:
Kambiz
From: "wrmosca@comcast.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, August 12, 2015 5:43 PM
Subject: [MS_AccessPros] Re: Populate a field according to value of two other fields.
IIf takes 3 parts. Part 1 = epression, Part2 is return if expression is true, Part3 is returned if expression is false. You can nest IIf statements.
SELECT IIf([FieldA]="Kaiser" and [FieldB]="Doctor", "Visit",IIf([FieldB]="Fee","Payment","")) As myResult
FROM myTable
__._,_.___
Posted by: Kambiz Afshartous <kenaf42@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar