sempuritoza
Programmer
greetings,
i have a bit of a problem with a query that i am qorking on, if the explanation is bad i do apologise but it is rather tricky to explain but to put it into a nutshell i have a query that is joining 4 tables and 1 of the tables contains perosnel information i.e. Name, Surname, etc this is the table with the Primary Key "ID_Number"(auto number)
This table is joined to the tables Contact Details, SchoolOrInstitutions(SOI) and SkillsMatrix(SM). A single person can have many SOI entries and many SM entries and the problem is that when i want to pull out details from all the tables for a single person i get a record back for each SOI entry thus if a person has 6 qualifications i get the same persons record back 6 times. I tried using the GROUP BY with the field ID_Number but this doesnt work how can i get a single record back for each person?
This has been bothering me for a while now and i geuss the answer might be wasy seeing that i am new to access but all help would be appreciated, maybe it would help if i also posted the query in the post but it is really long so im only gonna do that if i really have to...
thanx lata
i have a bit of a problem with a query that i am qorking on, if the explanation is bad i do apologise but it is rather tricky to explain but to put it into a nutshell i have a query that is joining 4 tables and 1 of the tables contains perosnel information i.e. Name, Surname, etc this is the table with the Primary Key "ID_Number"(auto number)
This table is joined to the tables Contact Details, SchoolOrInstitutions(SOI) and SkillsMatrix(SM). A single person can have many SOI entries and many SM entries and the problem is that when i want to pull out details from all the tables for a single person i get a record back for each SOI entry thus if a person has 6 qualifications i get the same persons record back 6 times. I tried using the GROUP BY with the field ID_Number but this doesnt work how can i get a single record back for each person?
This has been bothering me for a while now and i geuss the answer might be wasy seeing that i am new to access but all help would be appreciated, maybe it would help if i also posted the query in the post but it is really long so im only gonna do that if i really have to...
thanx lata