Search results

i have -ve value...(refer attachmenet) and my query.. Duration: Format([ReplacementLeave]![time in]-1-[ReplacementLeave]![time out],"Short Time") Minutes: DateDiff("n",[time in],[time out]) how to count total hours..:banghead::banghead: :D:D

here the pic what i want to do..

hi.. i have tbl workinghours inside the tbl there are -staff id -date - time in - data/time format : shorttime - time out - data/time format : shorttime in query..i already can count the duration.. eg. time in 8.30 time out 11.30 duration = 03.:00 now.. i want to calculated total...

deleted already... lol..

i tried opt 2 before maybe wrong code...hmmm...

after searching & trying..still cannot get the solution... let me breif more... i have this tbl.. tblProductCode - ProductCode - Product Description tblStockIn - productID -productcode - Quantity - SerialNumber - Invoice Number - Price - Date In tblStockOut - outID -productcode -serial...

hi.. i had form like in pic.. what i want to do is..when user select product code in combobox,the serial num combo box only show that serialnumber base on productcode cbo thanks for yur helps

when i click then button.. it didnt open the mainpage form..

Hi.. i trying to do simple login form but its not working.. i have this code.. Private Sub buttonlogin_Click() If Me.txtPassword.Value = "admin123" Then DoCmd.Close acForm, "f_login" DoCmd.OpenForm "f_mainpage" Else DoCmd.Close acForm, "f_login"...

Hi i have a table that contains product code for each item i have in store. now i want to generate report by each product code and in the form i planning to put combo box.when i choose produxct code from combo box ,there show me the reports. thanks for helping noob :banghead: