Recent content by Kasher

thank you very much JHB , it is sorted, i ve just replaced ";" with "," and it works perfectly:)

Ive tried it but it is not displaying anything as it should display DateTaken's correspondant type which is "H" after matching the date and pin no from tblMain.

I have got a table called tblMain with four fields, main_ID, Pin_No, DateTaken and type. And a form called CalenderForm for the month March. I want my form to populate the results after matching the pin_No and DateTaken from the tblMain with the form's textbox date values and vice versa and...

hi, i am trying to sum two fields (calculated fields from two different queries). for example i have 3 in field1 and 2 in field2, when i use tb:sum([field1]+[field2]), it gives me 32 insted of 5. here is my query snap shot pin_No emp_Name booked1 taken1 BT 0025 Phil...

i would like to thank you very much as your code (bank holidays and weekdays calculation one) solved my problem too.

I have found the solution from "fraseatwork" post. here is the code; Option Compare Database Private Sub Form_BeforeUpdate(Cancel As Integer) Dim dteIterator As Date dteIterator = Me!StartDate While dteIterator <= Me!EndDate If IsWorkDay(dteIterator) = True Then DoCmd.RunSQL "INSERT INTO...

thanks for the reply, I already mentioned that I am new to vBA. i did not understand your code. So can you please explain it to me. and how can i write that function to check bank holidays.

Hi I am new to VBA. I have got the follwing code which is working fi9. Now I want this code to check and ignore the bank holidays as well as it is excluding the saturday and sunday. how do i do it. I Have got one table with fields, id (autonumber), pin no(text), date taken (date) and type...

hi, i am doing a holiday tracker. i am ok to enter one record at a time in a field. for exmple i have a date field and a holiday field in a table. dt_id d_date holiday ----- ------ ------- 001 01/02/2013 H but if i want to book holidays for example from...

I have solve this issue with a help from Mr.Excel forum. it is as follow: val(nz([field1],0))+val(nz([field2],0)) and so on....

nothing wrong with your table design. here is the solution; in query grid create a field total:count([Date1])+count([Date2])+count([Date3])+count([Date4]) and in group by field select "Expression" ----------------------------------------------------- if there is a will, there is a way...:)

thanks for your help, i have done it like that. count(iif([field1]="H",0))+(count(iif([field2]="H",0)). and it is woking perfectly alright. there is one more problem, i have got 0.50 as a text in the same fields, how can i convert it into number after the count, actually it represents half day...

thanks for your reply. Well, after applying nz() function it is giving an error now. actually my fields are text data type. and i want to count fields only contain the character "H".

Hi, I want to add "H" from 3 columns into a total column in a query. couldn't be able to figure it out. for example, I ve one "H" in field1, and one "H" in field3 and field 2 is blank. I used this in query grid total:count([fileld1]+[field2]+[field3]), but it wont work only give 1 instead of 2...

Thanks for your reply, actually, I am not using the query. I am using the tables. I have attached the database if you want to look at it. primary table is in the form and many tables are in the sub forms.