Can I calculate a percentage increase in a table?

[mdnikki]

So I am trying to calculate a percentage increase in a table.

We have a field % Family Participation
We want to see a 10% increase this year in participation



So I want to use the field % Family Participation and add 10% to it to get a new field which will be 2021 Participation Goal

I can do this in a query but hoping I can accomplish this in a table.

Any help is appreciated.

Nicol

[ranman256]

tables do not calculate. only queries. (and forms)
the form can show the data in the table and have controls that can calculate using the fields.

i use queries. Q1 to get the %. then a form or Q2 to get the change in %.

[ssanfu]

It sounds like you have table design issues.

First, you should NOT use spaces in object names
Second, you should not use punctuation or special characters in object names (example: %)
Third, you should have a field in a table for "ParticipationGoalPct" and a field for "ParticipationGoalPctYear"

Without seeing your table designs, it is hard/difficult to make more suggestions.


Good luck with your project..........