Update Query Syntax

Posted on 2011-04-19
Last Modified: 2012-05-11
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?
Question by:kwarden13
    LVL 9

    Expert Comment

    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.
    LVL 26

    Accepted Solution


    In the subDelinquencies subreport Detail_Format code, you can whistle up a recordset to update this.

    Let me know.

    LVL 26

    Expert Comment


    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.


    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.
    The viewer will learn how to use the return statement in functions in C++. The video will also teach the user how to pass data to a function and have the function return data back for further processing.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now