Recent content by hoatranh

Please help me fix error, I don't why it can't run.

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 want create a link table with a excel file by import link. But I want to use VBA to import, not by tools. Please help me any way! thank you!

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 .... ...

oh Thank you veryvery much!!! I had do it! That is the part of the project about finance, I must do many ratio as X,Y,Z.... I can use Excel to do it, but it is not professional and vary slow. Thank you so much! When I finish, May I sent my project to you. May I know your mail? my...

Oh, sorry, I wrong.... I say again: I only have 1 table - that is YearlyRatio table. I want to use VBA or query to create a new table as Ratio, and the new Ratio table have 3 record X,Y,Y follow every year - The formula as: X=A-b; Y=A+B; Z=A+C. I send Ratio table only for example, I can't create...

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.

Thank you for your advice, but this table only the small in the big project with more table, query. So I don't want use excel and then connect with Access.

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!!!