Adding Columns to Tables

[KurtL]

However, your spreadsheet shows that the columns are sparse so that in fact, each assembly will have many fewer than 15 components. .

Each componenet is used in less than 15 assemblies but each assembly has like 50+ components on them on average.

Got one last question (ok yeah probably not my last) before i get too deep in restructuring my database. If the intention of the database for the time being is to be used to create a list of components on assemblies, is it really nescessary to normalize my tables when the database isnt being searched or anything. The only output to anyone other than myself is the report?

If the answer is yes it is nescessary, then how do i create a query with this new setup to display components listed by assembly with all the information information? Ive only been able to get it to list the part number only.

 

[Pat Hartman]

If the intention of the database for the time being is to be used to create a list of components on assemblies, is it really nescessary to normalize my tables when the database isnt being searched or anything. The only output to anyone other than myself is the report?

Then why are you bothering with a database? You would be MUCH happier with a spreadsheet. If you try to use a database like a spreadsheet, you will be VERY unhappy with the database

then how do i create a query with this new setup to display components listed by assembly with all the information information? Ive only been able to get it to list the part number only.

You probably don't want a single query. You probably want a report with a subreport. Or, you may want a crosstab query. However, the crosstab will not work for you if you will end up with more than 255 columns.

 

[KurtL]

I like how i can create queries to include only the information i want and then created a nice formated report for distribution in access. Ive done a ton of work in excel but i dont recall it having the ability to do any of that.

 

[Pat Hartman]

Yes, Access is capable of many things that Excel cannot do but you handicap yourself when you make your Access tables look like a spreadsheet.

 

[KurtL]

I like a challenge :-D