Recent content by hance

Thank you nschroeder! I will definately try your code out! By the way, below is the SQL I used, just in case anybody else need it in the future. Again, I appreciate the time you spent on the VBA code. I always hope I can do that too... SELECT wTbl02_Grouping_By_Ranking.Item_Desc...

Never mind. The problem has been solved by myself! I have been so close to the right point :D

yes, the raw data is extracted weekly, but I just replace the old file in the same location. no need to import to Access again and again. raw data doesn't have the rank and RowID. I copy and paste an emtpy table of the imported table and added a autocount column as rowid. Then, append the raw...

Are there anybody can take a look at my problem here? Thanks!

Thank you for your reply lagbolt! the raw data extract I got is a txt file. I imported it into Access and would like to build some report on it to run weekly. The first column has 6 distinct values from DisplayName to Text and they repeat themselves. For the Text records, its value in Detail...

Hi everyone, I'm stuck here for days. Can anyone help me with the table below please? The table has columns from "Item_Desc" to "Row". I would like to add another column "Rank2". It updates "0"s in blue cells into its group ranking numbers highlighted in yellow. And I would like to add add...

Hello everyone, My name is Hance. I'm from Toronto, Canada. I have been using Access for more than 2 years and consider myself to be an all-right Access user, but there are always some advanced problems stoping me for days:mad:. Now i really have to cut off here to post my question. Regards...