I have 1 table, and I want to use query to convert data in this table crosstab, I have enclosed this file. Please, help me solve this problem. many thanks!
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 .... ...
I have 1 table ratio, and I want to create a new table as YearlyRatio. The formula as: X=A-b; Y=A+B; Z=A+C. How can you help me! I don't know how to use VBA or query to do it! thank you so much.
I have 2 table YearlyRatio and Ratio, I want calculate every cell in Ratio for every year. example: cell ROE for 2003: I use IS_R024(2003)/BS_R080(2003). ROA: IS_R024/BS_R001. How can I use VBA or query to fill all of cell. thank you so much!!!