I know all things are possible....but....

[Sully38]

I have a 4 field database. 3 fields are text value, 1 is a numerical field. I am being asked to add a field to the table to show what % of the entire table each of the records makes up. Is this do-able?

 

[anvil19]

Hi Sully38

The general rule of thumb with database normalisation rules are that no field in a table should be dependant on other fields in the same table for its value.

It would be best to do what you are after in a query.

If you did as you are asked here, every time a new record is added to the table, an Update query must be run against the table and the new values added. Lots of things go wrong in these circumstances. Rather just use the query.

You could create a new table with the SELECT INTO statement using the same table name. SQL will delete the existing table and recreate it with the new data, but it will hit your systems rescources when the table gets large.

Any help??

anvil19

 

[Sully38]

I thought that to be the case... So did I use proper form by doing the following:
creating a 3 query run.
1st q. Grouping text and summing numerical value
2nd q. Getting Total of numerical field only
3rd q. Show all 4 fields plus a 5th field showing sum(current value/Total Value)

Then I drop 3rd q value into a data sheet form..for viewing pleasures or is there a better way?