Recent content by sparlaman1

Thank you! That makes sense.

I am trying to assign line numbers to records in my query. I have found the http://www.lebans.com/rownumber.htm Serialize Function as follows: Function Serialize(qryname As String, keyname As String, keyvalue) As Long Dim rs As Recordset On Error GoTo Err_Serialize Set rs =...

Interesting. That gives me a lot to think about. Thanks

So my boyfriend and I... j/k I can't wrap my brain around what I think I'm trying to do. I have some tables: tblcustomers, tblprojects, tblproposals, tblorders, tblpayments, tblcreditcards customers have credit cards (one to many) customers have projects (one to many) projects have...

Wahoo!!!! thank you Brianwarnock. Now that I properly input your formula it is working perfectly!!! (one of these days I'll learn to read properly) :) Again, Thank you very much!

I missed the Int in that equation. No wonder I wasn't getting the same result.. I'll try again

You’re right it shouldn’t but when I take 2 occurrences of the same data set where one occurrence is set to currency and the other is set to number, then I perform the same calculation on each, I get two different numbers using only the round function. I’ll give you the setup in a moment with...

well... i'm giving up on this. turns out the data that i'm working with is stored as type = currency and this data type rounds different from just a plain number. I am only linked to the data through odbc and not in control of the data type. so, I give up... but thanks for all your...

right. I want the answer to be 1.91. so the fourth digit is irrelevant in that example... except that access still uses bankers rounding so, I have a number like 5.666 and it's rounding to 5.66 instead of 5.67. So as of right now the -.001 works and I just need to force access to use standard...

OK, so... the first answer of adding .001 is still working best except that now I need to get access to stop using bankers rounding because ulitimately I need to take this number to only 2 decimal places. So next I'm going to try using this plus Ken Getz' custom rounding function. I think...

Ah... now I see the reasoning behind your second solution.. When I come across a number ending in .6666666 (etc.) and with an odd number to the left and bankers rounding I sometimes get .66 instead of .67 like I want. So if I do the *100 +.4 /100 it doesn't do that. Still you are brilliant in...

Thank you all for your suggestions. It's funny how sometimes the simplest solution can be the hardest thing to come up with. So far with my test data the subtraction of .001 is working perfectly! I'm going to play around with it for a while but I think that's just what I needed.

HI All! Problem: I want to "round" (to 2 decimal places) numbers 1-5 down and 6-9 up. For example: 1.915 = 1.91 1.916 = 1.92 I know this is completely screwy but I have to match numbers up to a purchasing system that seems to be doing just that. I've researched rounding in Access a lot...