Search results for query: *

Thank you TheAceMan1 It is not working. I want to track the user's names.Could you please give me more details.

I created a query1 with the expression to calculate minutes but it is giving an error. I tried to calculate the minutes on the cross tab query to based on the query1. When I ran the summary report on this cross tab query its giving each group the same value. I am doing something wrong that I...

I have the datasheet form1 on the main form. When the user clicks on a particular record, it will open the form2. On form2 there is a check box. I want to know how to track information that is checked and then after that its unchecked. Thank you

KLmorgan, Thank you, I did what you said. Its still not working. Could you please write more dedtails about the syntax as soon as possible because there is a deadline to finish this report. I will greatly appreciate if some one could help me.

Hi, Users are entering the hours and mts 8, 7.3, 6.3,9 etc. Creating a report every day , and every month. I created the cross tab query and I used the code below on the total column = Int(Sum((([total] - Int([total])) * 100) + (Int([total]) * 60)) / 60) & "hrs " & _ Sum((([total] -...

TheAceMan1, Thank you very much, it works very well, I just changed the peranthesis on the code. It works in the report. Can I enter the same code in the query also?

Hi PHV, Thanks for your time. I didn't exactly remember the error message but part of the error message is a syntax error.

Hi, JBinQLD and Seethru Thanks to the both of you . Me.refresh is not showing the newly added records. I used Me.requery . I entered the time interval every two minutes and its requering, but while in the process of entering the data/editing etc the hour glass is staying until the...

JBinQLD Thnk you, users are entering mts 0.15. Is there any way to remove the decimals .

Hi JBinQLD and SeeThru Thanks to the both of you for your time explaining it to me,It works. JB that is correct, the cursor on the form is jumping into the first record. How can I use the bookmark to reset to the relevant record. Please explain it to me. Thanks so much

Hi JBinQLD, I broke down the syntax into three components and the results are below: After I removed the fix on line below sum([mts])/60)=0.02 sum([mts])=1.35 (fix(sum[mts]/60)*60)=00 PHV, I tried your syntax also but it is not accepting, I am getting an error message. thank you JBinQLD...

Thanks JB I am a new program. Could you please explain to me in detail about the Time intervel property so i can set it. Also please give me a step by step, on where can I write the code . Thank you.

Hi All, I have a database shared on a network. If a user is entering data on a form, how do I get the information updated to an open form on the second user's computer automatically with the timer every 2 mts, without hitting shift F9 or the refresh button? i will be greatly thankful if you can...

Hi JB Run the report based on the date parameter for 15 days .The Total calculated minutes are 135. When I apply the formula above, it is giving 2hrs 25 mts. Its suppose to be 2hrs15mts. i dont know what i am doing wrong, please explain it.

Thanks to the both of you. Hi JB I used your syntax,but the mts is not printing correctly. Also Remou I tried your syntax also, it is printing zero. Please let me know how I can print the mts correctly.

Hi All, I created a report,that report is about printed hrs and minutes totaled. Minutes are storing 0.15 0.40 0.15 0.15 etc. I used the formula on the report: group footer. Ex. if total minutes are 205 i used the formula below. Sum([mts]/60*100) to total. The minutes are...