Search results

Hello, I ve created a db for employees workhours in which, a crosstab query is forced to display 31 days for each month and display values like "Sunday" , "Holiday", "Night". On the report texbox for each employee under month date i would like not to have "Sunday" , "Holiday", "Night" but just...

Hi i d like some help please, I need to count times per week, an employee has worked specific kind of duty, and i have managed that in the my query i have to calculate work hours weekly. All i need is to join holiday dates (which are not on Saturday and Sunday) and fall same day employee...

I have a listbox in a form which is controlled by values typed to unbount texboxes, but when an unbount textbox given a value brigs a results from sql statment query from a filed that has null values, the listbox does not populate with all records again from then on. Tryed whith the query but i...

John thank you, seems that works but the reason i keep stucking is.... that when the form starts the listbox inside is poplated by 131 records. After changing a value in texboxes lisbox is refering to, it should be populated in less records i agree. When erasing the values shoudnt all return...

I am using a lisbox in a form to show results depending on unbound textboxes. These textboxes function with on change event procedure Private Sub txtAM_Change() Me.txtAMX = Me.txtAM.Text Me.Listsearch.Requery End Sub When form runs it shows 131 records on listbox...

i say i agree with you and i need help to do that

I needed help from the first time ;)

I think it could be done whith some other criteria in the SQL statment.. Thank you John i shall try your way..

John it is kind the same, or isnt it i mean if i bind the listbox to a query excactly like my sql statement would that affect for the better?

Hello I have a form (listafrm) in my DB that uses a lisbox to return values depending on an sql statement which uses 8 unbount textboxes in the same form. The sql stetment i built is the same in stucture as another query i have in my DB (Qrsearch). Yet strangely that query instead of returning...

Could you please help? i need to calculate how many vacation days are there for employees in a db, so in a query, i use the dsum function in an expression trying to find if the specific empolyee had in the same year taken a vacation and subtruct the days from a total of 30 (days) I quess i m...

I utilised Stephen Lebans / Peter Schoeders serialize function to number query row [ΑΝΑ ΕΤΟΣ-ΜΗΝΑ] and with code: =Nz(DSum("[ΔΙΑΦΟΡΑ ΣΕ ΩΡΕΣ]";"[Qrevdomada]";"[ΕΠΩΝΥΜΟ] = " & [ΕΠΩΝΥΜΟ] & " AND ([Serialize]) < " & ([Serialize]))) in my report was a go.. Thank you all for your help. Probably it...

It is not working.. error again..

Here it is.. query is SynolaOron i want to have a result like report Qrminas the workhours of employees but for spesific month for each employee and to bring the previous month of his so then in the same report to be able to sum previus, due. and have a result because dayoffs are calculated by...

It refuses.. and insists.. thank you VbInet i ll try to think of another way two days is enough..

I know i would be pleased to know access like you and maybe you to know greek like me. I ll try that when i ll undreastand which would be the right names

no btw; [AllocationID] ? where ir what is that? [AllocationID]

Strangely ? i have a Query wich uses DSum("[ΔΙΑΦΟΡΑ ΣΕ ΩΡΕΣ]";"Qrevdomada";"[ΑΝΑ ΜΗΝΑ] <= " & [ΑΝΑ ΜΗΝΑ] & " And [ΑΝΑ ΕΤΟΣ] <= " & [ΑΝΑ ΕΤΟΣ] & " And [ΥΠΑΛΛΗΛΟΣID] = " & [ΥΠΑΛΛΗΛΟΣID]) and returns the results i want why wouldnt it work here. is there another way .. to bring month's (-1) results?

Tryes several variations with ' or " nothing error...

So what now shall i wait till that day! ;)