Search results

  1. R

    Query to see if type is present in table

    I have 3 tables: - tbl_Positions {containing information on a specific job role} - tbl_Office {containg information on an office} - tbl_StaffDetails {containing information of all staff in the company, inlcluding a relationship with tbl_Office to say which office they are working out of}...
  2. R

    2 Table to generate separate matrix table

    Thanks, will do
  3. R

    2 Table to generate separate matrix table

    Thanks Cronk, Took a little bit of understanding but got that sorted now. Didn't need Staff ID as it's only position and training I was interested in.
  4. R

    2 Table to generate separate matrix table

    This is my first post on the forum relating to my first foray into MS Access. I will keep it simple because I am thinking there will be a simple answer. I have 2 tables - Staff Position(Unique Position Name, Description, Hierarchy) - Training (ID, Name, Description etc.) I essentially want a...
  5. R

    Access Novice Needing to learn fast

    Thanks, I will do that. I've always built tables in excel in a structured manner, using validation lists from lookup tables, defined ranges etc. so hopefully it will help. Unfortunately I only have a month or so to get the first phase up and running alongside my normal 9-5 day job so...
  6. R

    Access Novice Needing to learn fast

    Hi all, Over the next few weeks and months (at least) I will no doubt be frequenting this forum on a regular basis. I have a strong background in using Excel and in particular applying VBA. However, recently I have undertaken a project for a company in the North East of England to...
Back
Top Bottom