FIELD AREA CLASSIFICATION

[Konneof]

Good day, I have a problem with Access. I want to sort a question. Imagine that 3 names have been registered. Α-Β-Γ, next to there are 6 fields, 1-2-3-4-5-6. Various values are recorded within the fields. e.g. 6,30-6,70,6,80-5,10- etc. I would like a member to help me (if he knows) how the classification will be done in the following way. Field 1 is easy to sort. but when we record the values in the 2nd field I would like the values of both the 1st and the 2nd field to be sorted. Then, when we enter the values in the 3 field, the classification should be done in relation to the 1-2-3 field, etc.
If there is a member to help me .....

 

[Ranman256]

Your table layout is wrong, not normalized.
it should be:
Name, Value
A,630
A,670
B,510

 

[arnelgp]

if i understand you, create a Query and sort on Val([field1] & "") + Val([field2] & "") + Val([field3] & "") + Val([field4] & "") + Val([field5] & "") + Val([field6] & "")

 

[Konneof]

Your table layout is wrong, not normalized.
it should be:
Name, Value
A,630
A,670
B,510

 

[arnelgp]

i made a sample and not sure if this is correct.
open query1.
see module1 for the function.
see class table for the classification.