Search results

But, I am not looking to add the numbers up. If you look at the Excel file and click on the yellow highlighted box, you would be able to see the formula, which is what I am trying to replicate in Access. It'll be great if you could help me with the formula..

I have already imported the data that I need from Excel into Access with no problems. I am trying to create a query to calculate the returns I need but I am not familiar with Access as the formula is different from Excel. I have attached my Excel data set with an example (in yellow) of a...

I am looking for an Access equivalent of the formula I have in Excel. I am trying to migrate from Excel to Access. Thank you.

Thank you for the swift reply arnelgp. Sorry that I wasn't being clear in my earlier post. If my Excel formula is {=PRODUCT(1+C:174:C178/100)-1} whereby the array C:174:178 are part of a larger set of data (from C:10), how would I use the Sum() function - what do I type to get the same...

Hi all, I'm new to Access and need a lot of help. I am trying to calculate Year-to-Date (YTD) returns using monthly returns data. In Excel, I use an array formula - is there something similar in Access? Also, how do I create a dynamic range, such that each time I enter new monthly data, the...