Advanced Validation / check entry + previos records is less than a

[DiegoLight]

Merry Xmas to all.

I need to do some "Advanced Validation" on MS Access. I believe this is a
common problem, so someone should know a good trick

Person Project Dic Ene Feb Mar
OSORIO L Pro 1 100% 100% 100% 50%
OSORIO L., Pro 2 40%
OSORIO L., Pro3 >30%
This guy has only 10% Availability

The idea is simple, when you assigned someone 30% of his month to a project
the validation rule should checked the guy has 30 availability (adding the
other projects that he already work)

In simple words, a validation rule/procedure, that checks that the sum of
other projects + actual entry is less than 100%.

I already try using validation rules that calls a procedure, but it couldn't
do it.

I hope thas someo has some procedures for this

Thanks for your help

Diego

 

[Larry Linson]

Could you describe in a bit more detail _how_ you are assigning work to the
person? I presume this would be on a Form, or it could be in VBA code, or
???

Too, it appears your table design, if that is what you are showing, is
unnormalized. Unnormalized table design is likely to lead to difficulty in
implementation.

Larry Linson
Microsoft Access MVP

 

[DiegoLight]

You've got that one right "Unnormalized table design is likely to lead to
difficulty in implementation" It is a corporate Access Tool and I am trying
to make it work better, I cannot make radical changes.

Here is some more detaile. The form uses a quary related to three different
tables.

**** The Form looks like this ********
Name Projecto Jan Feb Mar Apr
OSORIO L Pro 1 40 % 100% 100% 50%
PEREZ C Pro 9 40%
OSORIO L., Pro 2 40%

Editing

I am trying to assigned Osorio to Project 3 a 30%. Validation rule should be
able to check, there is only a 20% available

Name Project Jan
OSORIO L., Pro3 30%

 

[John Spencer (MVP)]

You could try using DSUM function to get the previously entered value(s) and
then add that to the current entry. Without knowing field structure etc it is
very difficult to tell you exactly how to do this.