Search results

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

Hi there... I've run into a problem with my db :( When I'm trying to create users for it, apparently Access won't accept them when they try to log in from different computers. Is it a general problem with Access, or is it just me who's a noob with this?

How do I make the reports show in relations? I'm (as said before) totally new to everything that has to do with programming, and therefore I work in the visual way, and thus I need to have the reports shown in relations in order to work with it... Any ideas?

I haven't created a query for the specific field, but just tried to bind it... The funny part is, that I've used the same code in another report where it works (and yes it is spelled correct), but here it won't...

Hi. Currently I've been having troubles in my report, that when I ask it to generate a report for me, it contains a field where it requires that I fill in the value for the parameter, even though it has been specified to a specific table to aquire the data... How can that be?

Now it works... thank you very much for your help... :D