Search results for query: *

Hi, I had clicked the "Great Post? Star it!", but apparently I failed to notice the pop-up saying "Click here to confirm". So I've done that now. Hope it's good. Also, the query works fine if you convert to Single instead of double. So the answer appears to be "convert to floating point". It...

Hi, That WORKED! Awesome. Your first suggestion to double one or the other didn't work, but double Both of them did. It Also fixed the averaging problem too. I'm not 100% sure WHY it works, but I'm happy that it does. For now, I'm just going to go off and have a weekend. Thank You very much...

Well, I see my little query output looks a lot more squishy when actually posted than when I put it in here to begin with. Anyhow, The [Weight] and [NumCount] are both Integers, in both Access and SQL Server. The [WgtPer] is a calculated field created from them, [WgtPer] = [Weight]/[NumCount]...

Hi, Report ? Nope, no report involved, just a raw query. Text ? Nope, nothing involved is formatted text. Yes, I can see the decimal places. Results look like this: Weight NumCount WgtPer 297 165 1.800000 355 198 1.792929 304 162 1.876543 152 92 1.652174 363 152 2.388158 570 247 2.307692...

Hi, Interesting suggestion re: CDbl(), one that I hadn't tried. Unfortunately, it made no discernible difference.

Hi, I've sometimes broused my way to an answer here, but this time I had to join and ask the question myself. I'm using Access2010 on a Windows7 PC. The data is from an attached (via ODBC) SQL Server 2005 table, named "Logbook", which contains some 1/4 million records. I have a query which...