Search results

Hey thanks a lot guys, with your solution Jon K it is very easy and it is working anyway. I think for the other solutions I need more experience to realize them. Thank you again, Martin

Thank you for your answers. I will try to realize Johns version, because there I can take my crosstab and only have to change the related date. namliam: By "packed in a whole year" I meant that my report shows the complete year from Jan - Dec. So I would like to keep it like this and don't want...

Thank you for your fast answer. My Problem is the months are packed in a whole year, so where can I change the date there? My Code for the crosstab: TRANSFORM Sum(Horas.HRS_QTD) AS [The Value] SELECT Horas.HRS_USU_LGN, Horas.HRS_PRJ_COD, Projetos.PRJ_DSC, Projetos.PRJ_BusinessDom...

Hi folks, I have a database with all employees of the departement entering there hours they worked per day and per project. Now my Boss wants a report of every month, I already realized this with a crosstab. But now he told me that he wants a report where the month is starting on the 20th of...

Thank you for help Michael. Now I have a crosstab and it was very easy with the Wizard. I made without your file, because I have Access 97 and your file is 2k? But anyway thanks a lot Martin

No, I didn't make a crosstab. I try to learn it on my own and didn't hear about that. Can you explain me how to make a crosstab? Or I will try the Wizard, I just saw it thx so far

loops in query or report? Hi, I hope you can help me, I'm a newby in access working since 2 weeks on it. I'm working on a timesheet, where all workers of the departement have to put in der hours they worked per day on a specific project. So I splitted it into 3 tables (Employees, Hours...