User Profile

Collapse

Profile Sidebar

Collapse
limpsharp
limpsharp
Last Activity: Mar 31 '08, 09:20 AM
Joined: Jul 19 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • limpsharp
    replied to Query Tables Where A appears X Times
    in Access
    Hi,

    Yeah, i didn't give table names originally because i was happy to work with an "abstract" solution, i understand a fair bit about SQL, i'm just not sure what methods to make use of!

    I have the following tables i want to show date from and the fields within them:

    Areas
    mtm
    mtmPhone
    area [key]

    Employees
    techID [key]
    First Name
    Last Name...
    See more | Go to post

      Leave a comment:

    • limpsharp
      started a topic Query Tables Where A appears X Times
      in Access

      Query Tables Where A appears X Times

      Hi,

      I'm at the end of a work project and the final report has got me stumped.

      I have a table of employees, a table of modules and a link table of modules and employees and whether or not the employee has passed that module.

      There are 21 modules.

      I am trying to generate a report which shows each technician if and only if they have "passed" (yes/no field) all 21 modules.
      ...
      See more | Go to post
      No activity results to display
      Show More
      Working...