Hello all,
Im trying to merge some tables in access 2007, heres some detail
Each table was imported into access from excel spreadsheets
Heres a part of one of the tables
Bridgeport2IDExtensionSizeAllocatedPercentFilesDescription1Graphic Files4.7 GB4.7 GB52.4%9589Files containing pictures, images or mouse cursors2.jpg2.7 GB2.7 GB30.2%2154JPEG Image3.tif1.7 GB1.7 GB19.3%179TIF Image4.nlm0.2 GB0.2 GB2.3%999NLM File5.bmp0.1 GB0.1 GB0.6%161Bitmap Image6.gif0.0 GB0.0 GB0.1%5758GIF Image7.wmf0.0 GB0.0 GB0.0%94WMF Image8.png0.0 GB0.0 GB0.0%122PNG Image9.ico0.0 GB0.0 GB0.0%93Icon10.ps0.0 GB0.0 GB0.0%27PS File11.pcx0.0 GB0.0 GB0.0%2PCX File12Office Files and Documents2.4 GB2.4 GB26.1%6958Documents and files of office programs and PDFs13.xls1.7 GB1.7 GB19.1%4807Microsoft Office Excel 97-2003 Worksheet14.pdf0.5 GB0.5 GB5.9%794PDF File15.doc0.1 GB0.1 GB0.7%508Microsoft Office Word 97 - 2003 Document16.frx0.0 GB0.0 GB0.3%538FRX File17.ppt0.0 GB0.0 GB0.1%182Microsoft Office PowerPoint 97-2003 Presentation18.rtf0.0 GB0.0 GB0.1%37Rich Text Format19.xlt0.0 GB0.0 GB0.0%12Microsoft Office Excel Template20.pot0.0 GB0.0 GB0.0%47Microsoft Office PowerPoint 97-2003 Template21.dot0.0 GB0.0 GB0.0%28Microsoft Office Word 97 - 2003 Template22.mpp0.0 GB0.0 GB0.0%2MPP File23.xls 0.0 GB0.0 GB0.0%1File24.pip0.0 GB0.0 GB0.0%2Microsoft Office Settings File25Miscellaneous Files0.6 GB0.6 GB6.3%10804Unknown file types26.q0.1 GB0.1 GB1.4%756Q File27.ind0.1 GB0.1 GB1.0%23IND File28.npm0.1 GB0.1 GB0.6%29NPM File29.a0.1 GB0.1 GB0.6%34A File30.cdx0.0 GB0.0 GB0.3%428Database Index31(none)0.0 GB0.0 GB0.2%1219No file extension32.ham0.0 GB0.0 GB0.2%100HAM File33.lmo0.0 GB0.0 GB0.2%82LMO File34.fpt0.0 GB0.0 GB0.1%125FPT File
Those are all of the fields, so each table will have ID starting at 1 but for example, Graphics Files may be lower on a different table if there are less.
I want to combine the tables in such a way that I just add up the size, allocated, and files fields
Is there an easy way to do that?
Im trying to merge some tables in access 2007, heres some detail
Each table was imported into access from excel spreadsheets
Heres a part of one of the tables
Bridgeport2IDExtensionSizeAllocatedPercentFilesDescription1Graphic Files4.7 GB4.7 GB52.4%9589Files containing pictures, images or mouse cursors2.jpg2.7 GB2.7 GB30.2%2154JPEG Image3.tif1.7 GB1.7 GB19.3%179TIF Image4.nlm0.2 GB0.2 GB2.3%999NLM File5.bmp0.1 GB0.1 GB0.6%161Bitmap Image6.gif0.0 GB0.0 GB0.1%5758GIF Image7.wmf0.0 GB0.0 GB0.0%94WMF Image8.png0.0 GB0.0 GB0.0%122PNG Image9.ico0.0 GB0.0 GB0.0%93Icon10.ps0.0 GB0.0 GB0.0%27PS File11.pcx0.0 GB0.0 GB0.0%2PCX File12Office Files and Documents2.4 GB2.4 GB26.1%6958Documents and files of office programs and PDFs13.xls1.7 GB1.7 GB19.1%4807Microsoft Office Excel 97-2003 Worksheet14.pdf0.5 GB0.5 GB5.9%794PDF File15.doc0.1 GB0.1 GB0.7%508Microsoft Office Word 97 - 2003 Document16.frx0.0 GB0.0 GB0.3%538FRX File17.ppt0.0 GB0.0 GB0.1%182Microsoft Office PowerPoint 97-2003 Presentation18.rtf0.0 GB0.0 GB0.1%37Rich Text Format19.xlt0.0 GB0.0 GB0.0%12Microsoft Office Excel Template20.pot0.0 GB0.0 GB0.0%47Microsoft Office PowerPoint 97-2003 Template21.dot0.0 GB0.0 GB0.0%28Microsoft Office Word 97 - 2003 Template22.mpp0.0 GB0.0 GB0.0%2MPP File23.xls 0.0 GB0.0 GB0.0%1File24.pip0.0 GB0.0 GB0.0%2Microsoft Office Settings File25Miscellaneous Files0.6 GB0.6 GB6.3%10804Unknown file types26.q0.1 GB0.1 GB1.4%756Q File27.ind0.1 GB0.1 GB1.0%23IND File28.npm0.1 GB0.1 GB0.6%29NPM File29.a0.1 GB0.1 GB0.6%34A File30.cdx0.0 GB0.0 GB0.3%428Database Index31(none)0.0 GB0.0 GB0.2%1219No file extension32.ham0.0 GB0.0 GB0.2%100HAM File33.lmo0.0 GB0.0 GB0.2%82LMO File34.fpt0.0 GB0.0 GB0.1%125FPT File
Those are all of the fields, so each table will have ID starting at 1 but for example, Graphics Files may be lower on a different table if there are less.
I want to combine the tables in such a way that I just add up the size, allocated, and files fields
Is there an easy way to do that?
