[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.

You can do this in a query like this:

SELECT IIf([FieldA]="Kaiser" and [FieldB]="Doctor", "Visit",IIf([FieldB]="Fee","Payment","")) As myResult

FROM myTable

__._,_.___

---

Posted by: wrmosca@comcast.net

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___