Search results
-
X
Running Total with criteria using UDF
Good Evening, After a couple months of head scratching, I have determined the solution to my problem lies outside of normal SQL queries and I need to create a UDF. Here is the problem. I need to create a running total based on the sum of two fields [PTS_ISSUED] & [PTS_REDUCED] with one...- xav78
- Thread
- Replies: 8
- Forum: Modules & VBA
-
X
Self-Referencing running total used to calculate next total in a query
Anyone and Everyone...., I have been working on a problem for over two months and I am spent trying to solve it. PLEASE PLEASE PLEASE there has to be an Access Guru to help! :) Here is the issue: I am trying to create a query that has a self referencing running total based on the values (point... -
X
How to create auto-grouping based on change in previous record
Good Day All, Looking for some support with this example below, I have a column "CAT" each time that CAT switches between 0 and 1, I would like my query to auto-create a "grouping" and increment the group by 1. What I am looking for is the output as shown below. Any suggestions would be...