Search results

Oh gosh. Either and both of those sound good but I'm not sure how to use them. If you could explain how or direct me to somewhere that does (that RowNumber link was confusing) I think I'll be on my way. Thanks.

The query comes back sorted already. Sorting it ascended doesn't change anything. The problem is that the transaction # field is not consecutive in the query (because the table includes transactions from different accounts). The result is that the query results of transactions # are...

I'm not exactly sure what that means. It's probably my unfamiliarity with Access but I don't know what an OrderBy clause is. What I do know is that besides displaying fields from a table, the only additions to the query are three formulas and a 'criteria': a: [In]-[Out] b: DLookUp("[a]","Am...

Ok I've run into another problem. From the query sample file you directed me to I was able to display the previous record using DLookup() and use that to create a running balance successfully, sort of. I use the function thus: Previous: DLookUp("[a]","Visa","[#] = " & [#]-1) The problem now...

Thanks for the reference material. After sorting through it I think it will give me what I need. If not I'll post again. Thank you once more.

I've been trying to create a running total in a query but can't seem to figure it out. I checked multiple sites on the web with no luck. They directed me to use one of two routes: SLQ or the DSum() function. No matter which one I try to use this message pops up: Microsoft Office Access has...