Recent content by sylvos

The Cdbl fix works perfectly, it's still slightly different in that it now has the number as -1.95587397421084E-02, but that's not an issue at all. Thanks for your help. (I am still curious as to the why, but oh well)

A fair number. Rounding errors can add up, and I want to minimize those. Ideally I'd want so that when I tally up all Y/X*X I'll get Y to the hundredth decimal place. I'll have to try the Cdbl fix tomorrow morning. I'm still curious as to why one of the calculated fields would need it, and the...

I don't think It'd work. At least, I don't see how to do it. Basically this table is about 45 records with grouped sums. It's built off another table with 10,000 records. Sums up all records in Group A in year 1, Group B in Year 1, Group A in year 2, etc. So what's going on is that on the...

Hi there all, I'm a bit of an access noob, so please bear with me. I have a query that among other things, takes two numbers and divides them by each other to calculate the percentage. This percentage calculation work perfectly fine when I use a select query, but if I try to change it to a...