Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2015
    Posts
    1

    Unanswered: Access 2013 One Field based on 3 fields in 3 tables

    I need code to do the following and where do I put the code? in a field in my main DB or in a query?

    Basically need to pull WBS code from original field and if "?" pull from GL Acct Name and if still "?" pull from Assign WBS - Fallout table

    Tables
    Details with WBS Desc
    GL Acct Name
    Assign WBS - Fallout

    Logic:
    If #1 Table[Details with WBS Desc] Field[Work Breakdown Structure Identifier] is "?" then

    If #1 True
    IF #2 True vlookup table [Details with WBS Desc] field GL_Account_Name in Table[GL Acct Name] Field GL_Acct_Name and if found return field WBS_Code

    If #2 False
    vlookup table [Details with WBS Desc] field Transaction Description in Table [Assign WBS - Fallout] field Trans Desc and if found return field [WBS Code]

    If #1 FALSE not equal to "?" then return field[Work Breakdown Structure Identifier]
    Last edited by Juwel; 11-24-15 at 15:30.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Use a join in a query and a compund iif
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •