Search results for query: *

Thanks Dave, that is great.

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

Skip, I can take a bollocking, I have been doing this project among a load of other things, and under pressure of having very little time to turn this bit around (I did not choose the launch date, someone on a much higher pay grade did that). I have legions of track engineers out there to whom...

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.

OK, here are some results: @SkipVought A1 - B1 = 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...

@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.

Hi, any help gratefully received: I am working in imperial (Miles/Yards) and have found that it is not possible create a custom number format that will deal with imperial linear distances: yards and miles. Put simply, I need to determine the difference in Miles and Yards between e.g. Mileage...

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...