how to use query to calculate financial

[hoatranh]

I have table financial, I want to create a new query with this:
COLUMN2004 2005 2006 2007
revenue growth IS_R010(2004)/IS_010(2003) .... .... ....
Cash ratio BS_R003/BS_R060 .... .... ....
ROA IS_R024/BS_R001 .... .... ....
ROE IS_R024/BS_R080 .... .... ....
Interest (IS_R05+IS_R022)/IS_R022

Please help me, because I have many ratio. Thank you so much

 

[ajetrumpet]

Keep in mind that my comments are only aimed at helping you...

You have 10 different "items", or rather "financial measurements" listed in your table, but only 1 company. Unless this is a very small part of a larger database that you are working with, I would switch to Excel. Doing this stuff in Access will only yield frustration for you, as Access is not designed to do stuff like this effectively.

In all honesty, the table in your database looks like a comparative balance sheet over a 4 year period that should be written out in an Excel tab...