Expression Builder for query lookup RRS feed

  • Question

  • I have an Office 365 business account.  My question concerns a simple MS Access database where I want to populate records on a report.  I want to pull a report record from an existing query.  The query has the following items:   ID, Name1, Name2, Text1, Number1, Number2.

    I want to pull Number1 for record Name2 = "JohnCalvin".  I do not know the proper structure to use in the expression builder.  Should I use Vlookup(); which records needs quotes (" "); which records need brackets ([ ]); what format should the criteria have?  

    Monday, February 11, 2019 3:21 PM