Recent content by 420canuck

Thanks for the input spikepl. On my computer that function only does approx. 0.5 million iterations per sec (vs. the 2.9m ips I'm already getting) so it would be a step backward. Any other ideas?

I should also mention that the intended function of RoundMe is to round-up all ties, and round-down all negative-ties. This is per accounting standards in a region I need to support. For example: if a customer's invoice total is 10.225 (RoundMe to 10.23) and there is a refund process for...

Hello all. I'm looking for some help optimizing a custom rounding function. The function replaces Round (aka "bankers rounding", aka "round-to-even") in cases where there is a tie (5 as the trailing digit to be rounded). When the notorious 5 is not involved I rely on Round because it seems...

I've followed this site for quite some time now... great discussions and I've learned a lot about access here. Time to post some questions for which I don't have answers... hopefully they help others too. I'm a Canadian living in India, have been using Access for over a decade on and off, and...