Search results for query: *

Is there a way to change this numbers to hh:mm:ss? These are seconds 292 29 54 286 57840 I'd like to create a column next to the "seconds" column and have Excel to convert the above seconds to hour-minutes-seconds. "00:00:00" Thanks, Rita

Hello, I'm doing calculations on date fields and I need to use the if or Iff condition. I've never used it before. Can anybody help me on accomplishing this? Does it have to be done in Visual Basics or can I do it at the query design view? Below are examples on what the data looks like, Start...

Hello, I need to convert this 0:12:57 to seconds I'm not sure on how to do it in Excel. I tried doing this =convert(A2,"sec") but I get an error. Thanks, Rita

I have two fields like Beginning date ending date 4/13/2006 16:02:29 4/13/2006 16:03:05 I calculated the latency between the two fields by doing this, =TEXT(J2-I2,"h:mm:ss") Now, I'd like to get an average, but I can not seem to get it to work. I tried to do something like...

Hello, I need to do a date/time calcutation with two fields. Find the latency between the two dates and time or just the time. In other words, how long it took the Problem to get validated. Then, I need to get an average. I have to fields 1. Received The information in here looks like...

Hello, I have a problem with my dates field on a form, I have text boxes that when are clicked, Access puts in this__/__/__ in the text box. I'd like for when a user clicks on the text box, the cursor to start at the very beggining, so in this case the first __/ and not the third __/ and when...

I have a spreadsheet with six columns "A,B,C,D,E,F" and 1000 rows. Numbers is all I have in each column I'd like to be able to search for six numbers. For example, if I type in a cell the following numbers 1-25-33-53-29-7 I want Excel to tell me if those numbers exist within my existing data...

Hello Folks, When I open a report, Access will not let me click on the reference links that the report is showing. Is there another way to do this? Each record in my database has a link like "http://tek-tips.com/threadminder.cfm?pid=703" When a user is looking at the report(s), that link will...

Hello Folks, I created this function, Referenced_Document_Id: IIf([tblReference].[Referenced_Document_Id]," ","No References Found",[tblReference].[Referenced_Document_Id] In other words, I'd like for access to add "No References Found" whenever a record from the tblStatutes has not...

Hello folks, I have a problem with my current form frmMain. It has two combo boxes, two text boxes ( for dates purposes) and a command button called cmdEnter. Everything works fine except the date's text boxes. if I enter the following from 01-01-05 to 12-29-05, or from May-2005 to Sep-2006 it...

I created a MS Database and everything works good except I'd like to enhance the form where I keep all the reports. Currently, each report,three different reports have a combo box and its respective command button that says "Preview Report" When the user selects a criteria from the combo box...

Hello, There are some things I still don't know about Access, but I'm learning. I created an Access database and this database will be residing on a network. My question to you is, Can more than one person access the database at the same time without having any problems? Data entry will not be...

Hello, this is the problem I'm having; I have a form that has a command button on it. When the command button is clicked, a parameter box pops up asking for a whole or partial number. I created a query using to tables. In one table I selected a field called Document_ID along with other fields...