Search results for query: *

I am trying to construct an analytical graph. Below is sample data Name Monday Tuesday Wednesday Total ------------------------------------------------- ABC 2 2 2 6 EFG 5 5 5 15 I am trying to make a Bar...

Thanks PHV, that worked like a charm!!!

That did not work Jerry. It crased on the follwoing line "Name OldName As NewName" and the error message was: RUN TIME ERROR 53 FILE NOT FOUND

I am using Access vba. A text file is copied from the server to a network drive. What I am trying to do is copy this file form one folder to another. Except when the file is copied to the destination, I also want to include a date stamp in the file name. Following is what I am using and it...

Hello there, I have designed a database which opens in the compiled mode. Now when you press the shift key it will open in design mode. I want to open in design mode with a batch file. I have tried the following code. z: CD\MED_SERVICE\Manpower ManPower.mdb /x It still opens in the compile...

Ok I got this to work sort of. Here is my revised code. PARAMETERS [Forms]![Transaction Details]![cbo_client] Text ( 255 ), [Forms]![Transaction Details]![cbo_cont_num] Text ( 255 ), [Forms]![Transaction Details]![txt_start_date] DateTime, [Forms]![Transaction Details]![TXT_end_date] DateTime...

I have a crosstab query which is two joined tables giving a sum of hours worked. Now on my form I want to be able to select certain fields for a criteria. I want to search by * Sold to Customer Name * ContractStartDate (Greater than or equal to) * ContractEndDate (Less than or equal to) *...

I tired it but no luck. Maybe something wrong with the formula.

Hello there. I have a field of Hours and Minutes. I need to add them to get the total number of hours consumed. The hours fields I can add without any problems. The minutes field I want to convert to hours. This is what I have Minutes ------- 60 65 Total of this is 125 which is 2 hours and 5...

Thanks it worked!!!

How would u incorporate the TIMESERIAL function in the query? would it be timeserial(text),(hour, minute, second)

I have imported a large data file in to Access. I have a whole bunch of values for time. They are in a text format and I need to convert them to time. Activity Start Time 083000 093200 090500 100500 092800 I need to get it into the following format. 8:30 9:32 9:05 and so forth Is there a...

Thanks for the feedback. I'm working on it now and will let you know the results.

I figured out that its not because of a long field, rather its because of multiple occurances of "V

Hello all. I have to do a bit of data cleaning. Below is sample data. CANON INC.CANON DIGITAL CAMERA SUPPORT LIBRARY V1.0.0.1 CANON INC.CANON DIGITAL CAMERA SUPPORT LIBRARY V3.6.0.0 CANON INC.CANON DIGITAL CAMERA SUPPORT LIBRARY V4.5.0.0 CANON INC.CANON DIGITAL CAMERA V1.0.0.19 CANON INC.CANON...

Isnt there any way I could start the search from the Right, that way there is a guarantee that only one V will show up

No there will be Vs in other parts of the data.

Thanks this sort of works but not for the long fields such as CHARON SYSTEMS INC.CHARON UNIPRINT SERVER V2.10.0892

Hello all. I have to do a bit of data cleaning. Below is sample data. CANON INC.CANON DIGITAL CAMERA SUPPORT LIBRARY V1.0.0.1 CANON INC.CANON DIGITAL CAMERA SUPPORT LIBRARY V3.6.0.0 CANON INC.CANON DIGITAL CAMERA SUPPORT LIBRARY V4.5.0.0 CANON INC.CANON DIGITAL CAMERA V1.0.0.19 CANON INC.CANON...

I think I got the SQL for this. This is what I put. UPDATE tblToBill SET new.FinalChargeRate = tblToBill.WaterRate * (new.Reading/old.Reading) FROM tblToBill new, tblToBill old WHERE new.[Unit Number] = old.[Unit Number] AND new.ReadDate = old.ReadDate; However I get this error: "Syntax...