Recent content by wrlgrain

Works Great!!! Thanks again.

I forgot to mention that I added a column to TransmasTotalsCornQ2 and the other queries TransmasTotalsBeansQ2 and TransmasTotalsWheatQ2 that will show the commodity for each record in case it has to be evaluated in the Select Case statement.

In the module, you define a new function for runtotal using the following code: With CurrentDb.OpenRecordset( _ "select [Sum Of Totbush] as expr1, [fiscalmonth] from [TransmasTotalsCornQ2] " & _ "where [cropyr] = " & CropYear & " order by [cropyr], [fiscalmonth];") My...

Was able to get it working by clicking on the following in the Tools, Reference section of module3: Microsoft Office 16.0 Access database engine Object Library Thanks again for your assistance:)

When I added the module to my database and changed the TransmasTotalsCornQ2 to reflect your solution, I get a compile error. See attached. Any thoughts

In your Zip file, I only find query1, the table and the module. Was there also supposed to one called query? Will the module work if TransmasTotalsCornQ2 is a query rather than a table?

I meant to say the post from arnelgp. Thanks to everyone for their assistance.

The DSum formula that was being used was the following. The post from plog appears to be a workable solution. I will give it a try. RT: Format(DSum("[Sum of Totbush]","[TransmasTotalsCornQ1]","CropYr=" & [CropYr] & " And No<=" & [No]),0)

Thank you so much. It looks like your query will do what I am looking for. I will give it a try.

See attached excel spreadsheet. Columns A - G represent the results of the access query. Column H was added to the spreadsheet to show what column E, "RT", should show. In the spreadsheet the "RT" value for No 24161 is 445575 which is the grand running total for entire crop year of 2013 from...

Thanks for your comments. Our fiscal year (ie CropYr) runs from June of one year to May of the following year. I am trying to get a running total beginning in June and ending in May. For this example, the calendar dates for June to December would be in 2013, while the calendar dates...

An Excel export of the query TransmasTotalsCornQ1 is attached.

Having trouble getting a DSum calculated field to produce a running total for grouped data. The table below is an excel spreadsheet that shows the result of my access query. The RT column calculates the total of "Sum of Totbush" for the year, but does not provide a running total by the fiscal...

My name is Roger and I am a intermediate at best to Access programming. I have a database that I have developed through trial and error and over the years and have picked up a few skills. I have taken a few online courses on VBA, macros, etc. that have enabled me to stretch my programming...