By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,045 Members | 1,384 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,045 IT Pros & Developers. It's quick & easy.

I have 5 fields that I need to equal 100%

P: 5
I have a table that has 5 fields and I need the % in each field to add up to 100%

For example:

Field1: 15% Field2: 25% Field3: 35% Field4: 20% Field5: 5%

Is there any way to have a validation rule to ensure these fields equate 100% for each record and if possible automatically fill the 5th field with the remaining percentage?

I am an Access beginner so take it easy on me. :D
May 19 '14 #1
Share this Question
Share on Google+
4 Replies

Expert Mod 5K+
P: 5,397
Simplest is to create a calculated control on a form and have the value double checked during the before update event.
Are you entering the data as 0.05, 5, or 5% the formating may make a difference in how you check the data.
May 19 '14 #2

P: 5
I have my fields set to:
Data Type: Number
Field Size: Single
Format: Percent
Decimal Places: 0

When 5 is entered in the field it displays 5%

Can you elaborate on how to do a calculated control or is it a straightforward method I can just look up?
May 19 '14 #3

Expert Mod 5K+
P: 5,397
click on the link provided in my last post, it will take you to the
basics on creating a calculated control.

Exactly what I needed on the field properties.

When you make your control, you might have to use the CSNG() to make sure things are added as numbers; however, with bound controls that isn't required.

Let us know how you get along...

May 19 '14 #4

P: 5
The field that contains the percentages is a combo box look up field value list. Will I need to delete these combo boxes and make new ones (5 percentage fields total per main form record) with an expression for each combo box that pulls the other 4 values together to check against 100%?

bit of a newb, I know, trying!:)
Jun 17 '14 #5

Post your reply

Sign in to post your reply or Sign up for a free account.