Search results

Dear All, need your help i have drop down list linked to table included "agent names" , the names appeared normally in the form but not Alphabetic (A-Z) although the table was alphabetic . any idea

yes result of the search

kindly advise i have 2 fields in Form "search Form" and i want once i change the data inside these fields reflect in the DB table so please advise with the VB update code

any idea i want to solve it

Hi all i have a problem i have field contains (minutes as number) like 5750 i want to convert thes minutes to short time hh :nn to be 95:50

any news i tried to show 1 entery in my report the time was 0:05 Min when i show it in the report it was 3.4722222222

this is my formula =DateDiff("h",[Dte],[Dte1]) & ":" & Round(((DateDiff("n",[Dte],[Dte1])/60)-DateDiff("h",[Dte],[Dte1]))*60,0) and i show it as short time example Aug-02-2014 12:00:00 AM - Aug-01-2014 1:00:00 AM = 23 :00

Hi all i create report and i want to sum field contains "short time hh:nn" but give me wrong result any suggestion

no sir once i put = Format([Dte1]-[Dte], "Long Time") give me 12:50 why i don't know once i put =DateDiff("h",[Dte],[Dte1]) & ":" & (((DateDiff("n",[Dte],[Dte1])/60)-DateDiff("h",[Dte],[Dte1]))*60) give me 0:50 :) thx for your effort

thanks for yor effort :) now working after my equation =DateDiff("h",[Dte],[Dte1]) & ":" & (((DateDiff("n",[Dte],[Dte1])/60)-DateDiff("h",[Dte],[Dte1]))*60)

=DateDiff("h",[Dte],[Dte1]) & ":" & (((DateDiff("n",[Dte],[Dte1])/60)-DateDiff("h",[Dte],[Dte1]))*60) finally

no :confused::confused::confused::confused::confused::confused::confused::confused::confused:

any idea :(

sir when i put your equation = Format(([Dte1] - [Dte]) - #00:00:00 AM#, "HH:NN:SS AMPM") he change it automatically to = Format(([Dte1] - [Dte]) - #12:00:00 AM#, "HH:NN:SS AMPM") why that i don't know

Dte format mmm-dd-yyyy hh:nn:ss AM/PM (Aug-01-2014 1:00:00 PM ) Dte1 format mmm-dd-yyyy hh:nn:ss AM/PM (Aug-01-2014 1:50:00 PM) X = = = Format(([Dte1] - [Dte]) - #00:00:00 AM#, "HH:NN:SS AMPM") still doesn't work give the same =12:50:00 AM

Dte format mmm-dd-yyyy hh:nn:ss AM/PM (Aug-01-2014 1:00:00 PM ) Dte1 format mmm-dd-yyyy hh:nn:ss AM/PM (Aug-01-2014 1:50:00 PM) X = = Format([Dte1]-[Dte], "Long Time") give me = 12:50:00 AM any suggestion

i Swear it's give me 12:50:00 AM

i tried it example = Aug-01-2014 1:00:00 PM -Aug-01-2014 1:50:00 PM give me 12:50:00 AM :( but it should give me 00:50:00 only

i put this =([Dte1]-[Dte])

Hi all, really i have 2 fields with format "mmm-dd-yyyy hh:nn:ss" i want to deduct the fields and the result to be "hh:nn:ss" i tried it but give me 00:00:00