Recent content by thierry.drouet

StepOne It works perfectly !! Thanks a lot and have a good day :-)

Hi everybody, Let's say that I've got the following tables: - tblCustomers(IDCust,NameCust) - tblEmployees(IDEmpl,NameEmpl) - tblProjects(IDProj,IDCust,IDEmpl,Duration) My query: SELECT tblCustomers.NameCust, tblProjects.IDProj, tblProjects.Duration, tblEmployees.NameEmpl...

Thanks apr for your reply, The first problem I think, is that the query using SumOfDuration doesn't provide the expected results: NameCust ------ IDProj - Duration ----- NameEmpl ------- SumOfDuration CUST1 ---------- 1 ------ 3 ------------ EMPL3 ---------- 3 CUST1 ---------- 2 ----- 10...

That's fine Rich :-) Now the enclosed zip file contains the 97 version !!! Thanks in advance

Number type !!! Is it a problem to look at the file I've enclosed? It's mdb I've done just to exposed that problem. I've thought it could an easy way !!!

That's what I've used to generate the above query: Sum(tblProjects.Duration) AS SumOfDuration, but I don't get the expected results !!! Any other suggestion?

Thanks for your quick reply Rich. It make sense. I've tried out by first modifying the query like this: SELECT tblCustomers.NameCust, tblProjects.IDProj, tblProjects.Duration, tblEmployees.NameEmpl, Sum(tblProjects.Duration) AS SumOfDuration FROM (tblProjects INNER JOIN tblEmployees ON...

Hi everybody, Let's say that I've got the following tables (Access 2003): - tblCustomers(IDCust,NameCust) - tblEmployees(IDEmpl,NameEmpl) - tblProjects(IDProj,IDCust,IDEmpl,Duration) What I've achieved to do is a report which lists: - the Customers (NameCust Header) -- then,the Employees who...