Search results

arnelgp, thanks for the report option it has given me thoughts of a separate issue I'm working on. However I need it in a query, the results are ultimately being displayed in a list box along with other relevant data points associated with the running total. any other thoughts maybe?

JHB: Thank you very much for your work but I've tried the query and worked the first time os I then loaded a larger dataset to test and the totals change as I scroll through, any ideas?

yes there is a Key field, I've attached a copy of the database I've been working in.

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

I will patiently wait with my fingers crossed :):rolleyes:

Thanks for the suggestion Uncle Gizmo, I actually looked at this already and did give me some ideas but turned out it was not my solution :)

Thank you for your feedback, I do understand the basic inherent differences between a database and spreadsheet, please excuse my hasty generalization. From my experience with working in both Excel and Access, I have found many similarities in data manipulation techniques and was hoping to seek...

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

Thank you very much to both PLOG and JHB, I apologize for not thanking you sooner! solutions both worked beautifully!

Ironically enough it is the last step I need. The output of this is required as it becomes the criteria for a running total query. :banghead:

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