I have 5 fields that I need to equal 100%

[feeeee]

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

[zmbd]

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.

[feeeee]

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?

[zmbd]

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...

(^_^)

[feeeee]

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!:)