Need help with organization Newbie

[dan@goditmaderanch.com]

I have a huge spread sheet, and I imported it into ACCESS, I would like to take the row which is computer name, which has Multiple entries and combine them into group, and then add the MB size in each column together, is that possible?

Thanks

[pbaldy]

Sure, create a query with those 2 columns. Click on the Totals icon on the ribbon, then change Group By to Sum on the MB field.

[dan@goditmaderanch.com]

ok, that worked, is ther a way to tell access, to combine like files, for instance I have a column named File Name, and I want to somehow show that when all the files end in .doc, Combine them and give me the sum of the size, and then also combine them by computername.

Is it possible?

[pbaldy]

Just doc or group by all the extensions? The first can be done with a criteria. The second would either require the Right() function if all extensions are 3 characters, or more likely a combination of the Mid() and InStr() functions.

[dan@goditmaderanch.com]

I honestly do not understand, I have not used access in a long time, and I really need a step by step

[pbaldy]

Apparently you decided not to wait, so I'll let any follow up happen here:

https://www.accessforums.net/showthread.php?t=63231