Search results

  1. L

    Filtering one field OR another field

    I've created a query which filters based on data in only one field, a checkbox, so the criteria is set to "Yes". How do I filter for data from the same field OR another field? I don't want the query to show only records where the checkbox for both fields is checked, but rather where one or the...
  2. L

    "Find" command button in subform error

    I've created a form which contains a subform, with a "Find" command button (among others) in both the "main" form and subform. It works fine in the main form but does not work in the subform - it simply doesn't find anything. The other command buttons in the subform, Save, Delete and Add, work...
  3. L

    Records that contain a certain word in a field (among other words)

    I have a database that includes an Address field, containing full addresses - street, number, city, state and country. I'm trying to create a query that will include only records that have a certain state in the Address field ie. NY. What's the syntax to filter for a full word among other text...
  4. L

    Combo Box hell

    I'm new to Access. I have a database with two tables - Companies, and Employees - by importing data from Excel. I've created a form including all the fields from both tables (Company Name is the primary key and I have established a one-to-many relationship). I'm trying to create a combo box...
  5. L

    2 tables better than 1?

    Bear with me, I'm new to Access... I'm creating a database of companies and 1 or 2 key contacts at those companies - started the process in Excel and ready to import into Access. Since I have multiple contacts for certain companies, the formatting of certain fields isn't good - what looks OK...
Back
Top Bottom