Search results

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 =...

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...

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...