Search results for query: *

Thanks PHV... that works very well

Hello everyone. I have a query that gives me the following results: Name SkillUsed TimeUsed Date Name 1 Skill1 20 8/1/2008 Name 1 Skill1 20 8/2/2008 Name 1 Skill2 10 8/6/2008 Name 1 Skill2...

Thanks Leslie, will try to structure my DB as you suggested and will keep you posted.

DUH... Never thought of using a UNION SELECT... all I had to do was: create 5 select queries (username, SkillX and TimeX) then create a query that would UNION the 5 into three fields... at that point I can sum the minutes, group the skills and group the usernames SELECT Username, Skill1...

Hi Leslie, it is necessary for the organization I work for to keep track of all the skills (or Core Competencies) and the time spent on each of them as there are minimum requirements to be met for the employees to be certified (each skill has to be used by a minimum amount of time, i.e. SKILL1...

Hi Leslie, thank you for the pointers. The DB will have to display how much time every user is spending on which skills (the issue on which they are spent is not important). Please check the attachment with the sample DB (I'm new at these) and tell me if the structure needs to be modified...

Hello everyone, I am trying to develop a DB in Access 2003 with the following structure: [USERS] = A table containing a finite number of usernames [SKILL] = A table containing a finite number of skills [TIME] = A table containing time periods in 10 mins. increments [MAINTBL] = A table that...