Constructing a customer inventory table calculated field

[Dclassen89]

I am trying to construct a table listing all of my customers as records and all of the items I sell as fields, I want to be able to calculate the percentage of items currently carried by the customer. So each item field will have to have a yes/no type configuration with a field that calculates the percentage of items carried. I just cant work out the best way to go about this. I already have most of the table setup I just don't know how to pull the percentage. Any ideas?

[JoeM]

Any calculations, such as percentages, should be done in a Query or in a Report.
How exactly those calculations are written depends on the structure of your data.
So perhaps you could post a small data sample and an example of your expected results.

[Xipooo]

Indeed, what JoeM said.

Whenever possible, you want to keep your tables strictly to just the data. Calculations on that data are what you use queries and VBA for. It will keep your database running faster, stay smaller, and you won't go crazy trying to update and insert tables every time something changes.

[JoeM]

It will keep your database running faster, stay smaller, and you won't go crazy trying to update and insert tables every time something changes.

Yes! I will keep your tables & database normalized and dynamic, while maintaining data integrity!
All critical factors to a well-designed database!