Search results for query: *

Thanks Dave, that is great.

Thanks zelgar, I will take a look at that tomorrow.

...date, someone on a much higher pay grade did that). I have legions of track engineers out there to whom I need to display the differences of *their* records accross two systems (one, creaking, predicated on flat files that was coincidentially commissioned in 1972) - and these engineers need...

Sheer incompetence Skip, as you have kindly established. Cheers.

Thanks @zelgar

@Skipvaught, are you asking me what the object of this exercise is, or just launching a personal attack ?

@skipvaught "It would have been helpful to state that your input cells (columns A & B) were expressed as M.YYYY. You seemed to imply that you simply wanted the RESULT to be expressed as M.YYYY and the inputs were MILES. " I had said "Put simply, I need to determine the difference in Miles and...

Well - a great thanks to all of you, and apologies for taking up your time. For clarification I currently work in the UK rail industry where data sets for assets going back a century in age are unfortunately recorded and reported in terms of miles and yards; perhaps I should have clarified this...

This works fine PHV. Thank you ! No hay nada como un buitre cabr=n como un ojo de cristal.

...= C1 25.1727 - 24.0880 = 1.0847 EXPECTED RESULT However, using A1-B1 I was getting 1.0149 But using =(D2MY(D1-E1)/1760)conversion to yards *1760 - I was able to get 1.0847 from D1) 44303.952 - E1) 42394.88 In a second example, A2 - B2 90.0836 - 89.1320 I expect to get...

@Skipvought; I spoke too soon, got some mixed results, will post how tomorrow. (Am not in the office today). Thanks again No hay nada como un buitre cabr=n como un ojo de cristal.

All, this has been extremely helpful and is much appreciated; I am now getting the results I wanted, can't thank you enough. No hay nada como un buitre cabr=n como un ojo de cristal.

Thanks Peter - that's exactly where I got my example from - however I can't seem to make the converstion to Miles.Yards No hay nada como un buitre cabr=n como un ojo de cristal.

Thank you zelgar, that is helpful - although I am struggling to apply this to show the result: CELL A1 - CELL B1 = CELL C1 25.1727 24.0880 1.0847 (I seem to be getting 0.0001) Thanks again OOS No hay nada como un buitre cabr=n como un ojo de cristal.

...36, 12, 1) FinalAnswer = "" For Each Item In Distances FinalAnswer = FinalAnswer & " " & Int(x1 / Item) x1 = x1 - Item * Int(x1 / Item) Next N2MYFI = Trim(FinalAnswer) End Function _____________________________________________ This function returns four...

Hi I have 2 tables with similar data TBL1 ROW | CO1 | CO2 | START MILEAGE 1 | ABC | 200 | 123.456 2 | ABC | 200 | 200.005 TBL2 ROW | CO1 | CO2 | START MILEAGE 1 | ABC | 200 | 400.00 2 | ABC | 200 | 125.00 I would be very pleased to know if there is some SQL out there that...

I did PHV, and it all worked fine earlier, thank you for that, bad day at the office yesterday ! No hay nada como un buitre cabrón como un ojo de cristal.

That's a good plan, I had avoided doing that because it's such a huge table, but I'll go for it now - cheers Skip ! No hay nada como un buitre cabrón como un ojo de cristal.

Thanks for the replies guys, so can I use SQL to convert the actual data type, or will I need to use Function/VB ? Thanks again No hay nada como un buitre cabrón como un ojo de cristal.

Hi, I have an Access SQL query to convert String to Numeric, however it is returning whole integers only - not returning numbers after decimal points. The table concerned has mileages in 000.0000 format as string, (it's data extracted from a very old database) however the SQL below is returning...