Recent content by nisa

unfortunately not... SELECT DISTINCTROW Arbejdsseddeltimer.ProjektId, Projekter.Projektbeskrivelse, Arbejdsseddeltimer.ArbejdsseddelId, Arbejdssedler.MedarbejderId, Sum(Arbejdsseddeltimer.Faktureringstimer) AS SumOfFaktureringstimer1, Sum(Projekter.Antal_Rek) AS [Sum Of Antal_Rek] FROM...

Ok I've tried now to put it under the workdate, and placing the line you guys have given me under tha criteria, but apparently I've done something wrong, cuz now it doesn't give me any data, no matter what I put in under reportdatearea... I've also tried to add it under all the other columns...

But where do I find the query criteria? That was more my question... sorry for the utterly crappy phrasing of question...

yup, that is correct...

Ok... now you got me confused... (I'm totaaly noob with this)... how do I change the criteria for the report?

I got this already: "For arbejde udført mellem: " & [Forms]![Rapportdatoområde]![Startdato] & " og " & [Forms]![Rapportdatoområde]![Slutdato] (It's in Danish sorry ;)) Translated it would look sometinhg like this: "For work done between: " & [Forms]![Reportdatearea]![startdate] & "and" &...

Hey! Now my DB finally is almost up and running, so now I only have one (maybe 2) question(s) left... How do I create a reportdate-field? What I tinhk of, is that instead of printing out the entire database, then I only want to print, for example, from the 1st of May 2006 untill 23rd of...

I found the problem, and as said by ajetrumpet, then the problem was simply my joins. By errasing one of the joins, then I made it work as it should... But thx for the help guys!

a subset? I'm not quite sure what that is...

I've tried something new, but now it complains that there's something wrong in the SQL or JOIN SELECT Arbejdsseddeltimer.ProjektId, Projekter.MedarbejderId, Medarbejdere.Fornavn, Medarbejdere.Efternavn, Arbejdsseddeltimer.Antal_Rek FROM (Medarbejdere RIGHT JOIN (Projekter INNER JOIN...

Tried to add a RIGHT OUTER JOIN insted of the second INNER JOIN, and it sort of worked, but now I get all the employees, but not all of them is under the cases where they have been set to work...

It's all generated with the Guide, so if there's something that looks suspect, then it's a bug in Access, which have made me do it :D

Hi. I've recently tried to create a quey which would give me the cases I'm working with, the name of the employee, and how many people the employee has "recruited" for the case. But for some odd reason the query shows only 5 employees out of 23, and they just loop them over and over. My SQL...

I'm not quite sure I understand I'm afraid... I've created a form now named userlogins, and set the properties etc. but how do I make it work in pratice?

That sounds as what I want to do, but the question is how to do it? This is my first time ever working with Access, so I don't know how to do half the stuff I need to :D