Recent content by jmak_1214

It is quite hard to explain. In any cases, thank you for all the help. It works for me right now with the SampleData3.zip. I was just trying to have 1 query instead of 2.

Updated the SampleData with JHB's calculation:

Thank you very much for your help. It is beautiful. But I actually need to add 1 row for each part count and then do the running sum. Please see the SampleData2.zip as attached in the above reply. Is there anyway to do this without using 2 queries?

I need this in query in order to set the layout of a exported excel file. The excel file has to exported in a certain way (which is kind of annoying).

Thank you. I have implied the code into my project, but it does not calculate the running sum. RecordID | PartCount | RowCount 1 | 1 | 9 <Default as "9" on Query 2 | 2 | 11 <=2+9, which is PartCount on 2nd record adding RowCount on 1st Record 3 | 5 | 16 <=5+11, which is PartCount on 3rd record...

Hi, here you go. Thanks in advanced. I want to add a column with RowCount.

Thank you for your warm welcoming.

Thanks, but in this case, I will always need the first record to be 9 and then sum below two columns.

Hello, I have tried to use "Get the value in another record" but i could not get the value from the record above. This is the code i have got right now. [CODE]SELECT SPQuoteTool.QuoteToolID, SPQuoteTool.SemiProductID, ToolingPhoto.ERPToolID, ToolingPhoto.ToolName, ToolingPhoto.NetWeight...

Thank you for you reply, but how about making the first RowCount be default "9", and then add PartCount?

Thank you for reading this thread. I have a problem with creating a query with calculation, please help: RecordID | PartCount | RowCount 1 | 1 | 9<Default as "9" on Query 2 | 2 | 11 <=2+9, which is PartCount on 2nd record adding RowCount on 1st Record 3 | 5 | 16 <=5+11, which is PartCount on 3rd...

I am currently working on a database for a personal project. Very new to Access!