Aloha everyone! This is my first here on the Access forums - but if I continue using this software the way I have been - it may not be my last. I'll start by thanking everyone for reading and doing their best to solve my problem. Alright - here's my dilemma...
I'm creating a basic database that will analyze financial data included on a firm's 10-K. I have been analyzing numbers throughout the semester and grew tired of manually calculating certain formulas. My intentions are to create a bunch of calculated fields that will do the work for me by relying on the data included on each sheet. I created a few tables, the ones at hand in this issue are "Income Statement", "Balance Sheet", and "Cash Flows". Each table has the relative financial data punched into it - and I intended on creating a query for each one. So far I'm stuck on the Income Statement Query. The purpose of the query is to calculate data using the information included in the relative sheet. For example, to determine a company's profitability ratio - you must divide their Net Income by their Revenue. I added all of the fields from the Income Statement into the query, and created the calculated field titled Profitability Ratio. This was input as [Net Income]/[Revenue] - I then formatted the field as a percentage and it did the work for me. Great! Now here's my problem: the next data I needed to gather is called the Interest Coverage Ratio. To determine a company's Interest Coverage Ratio you must perform this formula: (Net Income + Income Tax Expense + Interest Expense) / Interest Expense. As a pre-note - all of those fields are included (with data) on the table I titled "Income Statement". As all of the fields from that table are in the "Income Statement Query" - I didn't think I'd run into any problems. But here it is: I input the expression as [Net Income]+[Income Tax Expense]+[Interest Expense]/[Interest Expense] - and I get a message stating "Overflow". Furthermore, when I remove that final part of the expression (/[Interest Expense]) - the query runs fine and adds up all of the fields. All that I can theorize is that for some reason I am unable to use a field twice in an expression. Any suggestions? Thanks a ton guys. Aloha.