access vba inner join update

Posted on 2011-10-26
Last Modified: 2013-11-27
Syntax error. I need some help with an inner join in vba. Newbie stuff.. Thx
sSql = "UPDATE CData INNER JOIN pdata_positions ON (pdata_positions.Field13 = CData.ID) SET =;"

Db.Execute sSql

Open in new window

Question by:BillTr
    LVL 22

    Expert Comment

    by:Kelvin Sparks
    sSql = "UPDATE CData SET = FROM CData INNER JOIN pdata_positions ON (pdata_positions.Field13 = CData.ID) ;"


    Author Comment

    Sorry, that is giving me a runtime error  3075

    Assisted Solution

    got it.

    UPDATE [Pace-boa_eod_positions] INNER JOIN ComplianceData ON [Pace-boa_eod_positions].Field13 = ComplianceData.Cusip SET ComplianceData.ausi = [Pace-boa_eod_positions]![Ausi];"
    LVL 30

    Accepted Solution

    In general,
    UPDATE table1 INNER JOIN table2 ON table1.joinField1 = table2.joinField2
    SET table1.fieldToUpdate = table2.fieldToUpdateWith

    Author Closing Comment

    My solution was valid... but hnasr improved on it.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    728 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

    19 Experts available now in Live!

    Get 1:1 Help Now