Search results

Yes it returns error if i try as you recoment thank you for your help i don t know.. why..! very clever what you recoment though

No #error again..

So wow should i get it work? is there another way? how should the code be? =nz(DSum("[ΔΙΑΦΟΡΑ ΣΕ ΩΡΕΣ]";"[Qrevdomada]";"[ΕΠΩΝΥΜΟ]='" & [ΕΠΩΝΥΜΟ] & "And [ΑΝΑ ΕΤΟΣ-ΜΗΝΑ]<=" & (Format$(DateAdd("m";-1;[ΑΝΑ ΕΤΟΣ-ΜΗΝΑ]);"yyyy-mm")))) wont work.. returns #Error

Hello Bob =Format$(DateAdd("m";-1;[ΑΝΑ ΕΤΟΣ-ΜΗΝΑ]);"yyyy-mm") already works in another text box and i get the previus month eg if it is 2011-01 returns 2010-12 It is begining to get complicated. I would like total workhours of empolyee till the month (minus 1) the report is refferin to meaning...

Thank you Galaxiom Until =nz(DSum("[ΔΙΑΦΟΡΑ ΣΕ ΩΡΕΣ]";"[Qrevdomada]";"[ΕΠΩΝΥΜΟ]=" & [ΕΠΩΝΥΜΟ])) works ok using ; not commas here it is different yes, and [ΕΠΩΝΥΜΟ] is a field to display surname.. tried as you said =nz(DSum("[ΔΙΑΦΟΡΑ ΣΕ ΩΡΕΣ]";"[Qrevdomada]";"[ΕΠΩΝΥΜΟ]=" & [ΕΠΩΝΥΜΟ]& "' And...

i have a report which gives totals of workhours of empolyees per month (it collects data from a query to sum workhours over weeks) In my report i want the sum of workhours of the employees till the month previous to the one i am reffering to. i use a datepart function in my query to get the...

I made a db to calculate workhours of employees, their model of work and calculations constist of work per week and then per month. So each has at the end of the month some workhours worked. I need to bring last month workhours for every employee when i start using the database.. Here is my db...

What i need to ask is if you download my database, you shall see, a table named proigoumenesorestbl in which the field ΠΡΟΗΓΟΥΜΕΝΟΣΥΝΟΛΟΩΡΩΝ will contain the total of workhours employees have worked till time the database will start to be used. So lets say i fill in the worked hours. In the...

Chris thank you for your answers, What i need to ask is if you download again my database, you shal see, a table named proigoumenesorestbl in which the field ΠΡΟΗΓΟΥΜΕΝΟΣΥΝΟΛΟΩΡΩΝ will contain the total of workhours employees have worked till time the database will start to be used. So lets...

Thank you Chris. It was very helpfull, i was wondering if in that database wich will start be used lets say at the end of next month, how the workhours of employees till that day should be insert so that i envolve them in the calculations? Any idea?

i have a query (Qrminas) to calculate a running sum of workhours of empoyees per month and i get #error in the field ΣΥΝΟΛΑ SELECT Qrevdomada.[ΑΝΑ ΕΤΟΣ], Qrevdomada.[ΑΝΑ ΜΗΝΑ], Qrevdomada.ΥΠΑΛΛΗΛΟΣID, Qrevdomada.ΕΠΩΝΥΜΟ, Sum(Qrevdomada.[ΔΙΑΦΟΡΑ ΣΕ ΩΡΕΣ]) AS [ΣΥΝΟΛΟ ΜΗΝΟΣ], DSum("[ΣΥΝΟΛΟ...

Thank you find those links usefull

Thank you i find those links usefull

Here is my db, what i would like is to ask.. In query "Qr1" there in the last field i calculate workhours during weeks per employee. [u]I need a running sum of workhours per employee in a new field. I think there should be an expression with the funxion Dsum. Can you help? notice that field...

How could i insert the already result of workhours ( they are calculated in excel) as a number of every employee so they are calculated to the day i shall start using that database that calculates workhours per employee? Need to make a table? and how would the table connect to the table of...

Could a report sum the workhours for every employee, during weeks and months? That was my problem and that's why i am so stretched about managing the specific query. I think maybe report cannot find the previus workhours of each one and sum it because i need to have a report to present...

I realize its 03 10 here.. have a good night maybe db is not for the time. have an early start... ;) thank you so much

I am stuck.. an of ideas anymore saw somehere a counter mayby if there was a counter to give autonumber by employee somehow

I thought you had tha in mind.. and my apologies for keeping you without having told that. Thank you so much i am sure there must be a way.. if i bring datepart in the expression

Ok.. i am dissapointed by access if it is true.... Thank you so much and my appologies althought i thought we reached perfection...