I am trying to make a formula work and obviously have it wrong. Essentially if the field VNDAD1 equals an entered value, such as RETAIL ADVERTISING then another field VENDOR_CLASS will then equal E otherwise anything else gets an S. This formula I built on my limited (but learning) knowledge of Access in the expression builder.
Could someone please tell me what I did wrong?
IIf([Combined_PS]![VNDAD1]="RETAIL ADVERTISING" Or ([Combined_PS].[VNDAD1])="NEWS ROOM",[Combined_PS]![VENDOR_CLASS]="E",[Combined_PS]![VENDOR_CLASS]="S")
Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!
Or try our Ask An Expert service to answer any of your questions!