Search results

  1. G

    Using the IN operator with IIF in a query criteria

    I am trying to select specific records based on input in a query. This criteria currently works to select everything with an ID less than 21 or 31 based on the users entry: <IIf([Enter "Y" for List 1]="Y",21,31) I now need to change the query so that only certain records are selected based on...
  2. G

    Combobox Autoexpand Question

    Here are the applicable portions of my database design – tblMembers.MemberID (Primary Key) tblMembers.AddressID (foreign Key – Addresses table) tblMembers.FirstName tblMembers.LastName tblMembers.SponsorID tblAddresses.AddressID (Primary Key) queryMembersAddressIDs.MemberID (from tblMembers)...
    • gswan
    • Thread
    • Replies: 8
    • Forum: Forms
  3. G

    Select ONLY rows with a value, but do not otherwise appear

    I am trying to select the people in a table that exist with a certain value in one field, and do not otherwise appear in the table. Here’s a sample of the data in the table: Name IDNum John 1 John 2 John 3 Mary 1 Mary 2 Mary 3 Paul 2 Larry 1 Larry 2 Larry 3 Joe 3 I need a query...
  4. G

    Conditional Query to Concatenate Fields

    I have a table of data about people. The fields I'm working with are PersonID, FirstName, LastName, and SpouseID. PersonID is the primary key. If two people (in different rows) are married, they each have their spouses PersonID number in their SpouseID field. Single people don't have any...
Back
Top Bottom