<div>
Are you looking for guidance on how to write the SQL statement? Is your nested IF statement in SQL or do you use Access Macros or VBA code?<br />
<br />
It would probably be best if you can post the bit of code you already got so we can assist you better.
</div>


Are you looking for guidance on how to write the SQL statement? Is your nested IF statement in SQL or do you use Access Macros or VBA code?

It would probably be best if you can post the bit of code you already got so we can assist you better.

<div>
Thanks.<br />
<br />
I am back at my desk today.<br />
Thank you for your patience.<br />
If you want to ask a related question on that other stuff, we can work on it.<br />
<br />
Nick
</div>


Thanks.

I am back at my desk today.
Thank you for your patience.
If you want to ask a related question on that other stuff, we can work on it.

Nick

<div>
<div class="content wysiwyg-content">
I have a table that has a recommended action field. This field gets updated based on a nested IF statement. I want to add another statement to say if this ID&amp;ITEM ID&amp;YEAR exist aready on the table (more then once) then update recommended action to say &quot;MEMO&quot;<br />
<br />
How would I do this?
</div>
</div>


I have a table that has a recommended action field. This field gets updated based on a nested IF statement. I want to add another statement to say if this ID&ITEM ID&YEAR exist aready on the table (more then once) then update recommended action to say "MEMO"

How would I do this?

Update Query Syntax

A programming language is a formal constructed language designed to communicate instructions to a machine, particularly a computer. Thousands of different programming languages have been created, mainly in the computer field, and many more still are being created every year. The description of a programming language is usually split into the two components of syntax (form) and semantics (meaning). Some languages are defined by a specification document (for example, the C programming language is specified by an ISO Standard), while other languages (such as Perl) have a dominant implementation that is treated as a reference. Some languages have both, with the basic language defined by a standard and extensions taken from the dominant implementation being common.

Programming Languages-Other

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.