Search results

  1. N

    Using a combo box as a criteria for a query

    I have 2 tables: Table 1 = Position Names PositionID - Data Type = AutoNumber Position Name - Data Type = Text Table 2 = Staff Positions StaffID - Data Type = AutoNumber Last Name - Data Type = Text First Name - Data Type = Text Position Name - Data Type = Number, Display Control = Combo Box...
  2. N

    Linking First and Last Name Fields

    thanks ghudson!!
  3. N

    Linking First and Last Name Fields

    It IS a good practice when you are creating a database that has these tables: Staff Names Positions Names Training Courses Position Course Requirements Staff Courses Completed so that you can created a query to show you what courses staff have not taken in order to be qualified for your...
  4. N

    Linking First and Last Name Fields

    Right now I have a table with first and last names of customers as separate fields. I have a few other tables with their first name, last name, and other fields. These tables have to remain separate for some queries I am running. How do I link the First Name and Last Name...
  5. N

    Exclusion: How to show when staff have not completed a training for their position

    I am trying to set up a staff training database that will help figure out what trainings they still need to take for their positions. Here are the mock tables and fields I have set up. Table 1: Position Name Required Training 1 Required Training 2 Required Training 3 Required Training 4...
Back
Top Bottom