Ideally what I would like is if its 8 folders deep then 8 columns if just two folders deep then two columns.

Thanks Thom for the heads up. I will go through the link and probably re-post. Yes there are multiple subfolders, some files being 8 folders deep some just 2.

Thanks Steve for replying

Basically what I have is a database that contains a list of files, with columns
filename 
filesize,
dateadded
folderpath (their location on the...