Search results

Thanks The_Doc_Man. I have read explanations about this before, but it has never made sense, but now you describe the decimal as 0.10 as being 0.0001100110011... in binary, it does suddenly make sense! This stems from the assumption that dividing by 10 is the same as multiplying by 1/10 which is...

That's what 'User CP' is! I was using an old windows laptop over VPN and it was taking ages to load. Nothing there yet, so it might be the 10 post rule taking effect.

Minty - I might have a think about doing that. It did cross my mind too, but as someone else has suggested it, perhaps it isn't such a daft idea!

How do I set up a signature? I had a quick look in my settings but couldn't see where to do it.

Thanks Dave I agree that the proportions are the ones to worry about. If I want it to be precisely 0.00001234 should I append trailing zeros 0.000012340000 to prevent it being stored as another value? With a £10m value the difference between 0.00001234 and 0.000012399999999965 is 60p...

Hi have a requirement to use MS Access to store (in separate tables) cost data, and in separate tables, proportional allocation (values less than 1) so that I can do a multiplication in a query to multiply Cost x Allocation = Proportional Cost. The Cost numbers are ok - I can use Currency or...

I have been a reader of these posts for many years. It is now time to get involved and ask, and answer some questions.