Search results

  1. L

    Returning Field Value on Matching All Records

    Conceptually, I have the following two tables: Table 1: Group | Item ------+------ A | 1 A | 2 A | 3 A | 4 B | 1 B | 2 B | 5 C | 1 C | 2 C | 3 Table 2: Item ----- 1 2 3 I'm looking to return only Groups which contain all Items...
  2. L

    DoCmd.OpenQuery vs DoCmd.RunSQL vs OpenRecordset

    I'm in the process of designing an application which will source data from 5 separate tables (each subject to selection criteria), combine fields from each table, and finally append the records to another table. Since each of the source tables contains a large amount of data (on the order of...
  3. L

    Variable Assignment within IF Test Expression

    Hi All, A pleasure to be a new member of this forum; prior programming experience, but relatively new to VBA so I apologise in advance if my questions appear neophytic. This should hopefully be an easy one: As part of an existing if/elseif block, I'm look to test whether a table contains...
Back
Top Bottom