kareshi



Hello,

I have a table with these sample data pattern:
Col1 Col2
001 2
002 1
002 2
002 1
003 4
003 4
003 3
003 3
003 5

The expected output in the csv file will be exactly like this:
001,2
002,4
002,
002,
003,19
003,
003,
003,
003,

In the csv file, the number next to the topmost 002 is the sum of the Col2 where Col1
is 002 and the remaining field next to other 002 rows will be blank, the same process repeats for 003 and so on.

Would anyone
please help me to code this in VBA

k









Re: Refining MS Access data and saving to csv file using VBA code

kareshi




This Q has been answered here:
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=2185744&SiteID=1&mode=1