Equaision problem

1. Guido Brockmann (guido@em Guest

## Equaision problem

Hi happy new year to you all<BR><BR>I have got an equaision of the type<BR><BR>value (user defined thrue form) = (user def2 * x * p1) + (user def3 * y *<BR>p2) + (user def4 * z * p3)<BR><BR>I know the values of<BR><BR>value<BR>user def2<BR>user def3<BR>user def4<BR><BR>that I get from a form<BR><BR>and<BR><BR>p1<BR>p2<BR>p3<BR><BR>that I get from a table<BR><BR>How can I get VBSc to find me the highest possible values for x,y and z so<BR>that I could show it afterwards with an UBound of (x+y+z), knowing that the<BR>table where p1,p2 and p3 are stored has got 150 recordsets.<BR><BR>I have run out of ideas here and my brain is smoking....<BR><BR>Any help welcom<BR><BR>guido<BR>

2. Senior Member
Join Date
Dec 1969
Posts
96,118

## RE: Equation problem

(English is funny...it&#039s pronounced as you spelled it but spelled "equation.")<BR><BR>Anyway...<BR><BR>I don&#039t think your question makes sense!<BR><BR>Let me restate your equation:<BR><BR>U0 = (U1 * x * P1) + (U2 * y * P2) + (U3 * z * P3)<BR><BR>Now, let&#039s assume, for the sake of argument, that<BR><BR>U0 = 1000<BR>U1 = 1<BR>U2 = 1<BR>U3 = 1<BR>P1 = 1<BR>P2 = 1<BR>P3 = 1<BR><BR>So there are an *INFINITE* number of answers for x, y, and z that will satisfy that equation!<BR><BR>Examples:<BR><BR>1000 = (1 * 1000 * 1) + (1 * 0 * 1) + (1 * 0 * 1)<BR>1000 = (1 * 0 * 1) + (1 * 1000 * 1) + (1 * 0 * 1)<BR>1000 = (1 * 0 * 1) + (1 * 0 * 1) + (1 * 1000 * 1)<BR>1000 = (1 * 123456789 * 1) + (1 * -123456789 * 1) + (1 * 1000 * 1)<BR>1000 = (1 * 123456789123456789 * 1) + (1 * -123456789123455789 * 1) + (1 * 0 * 1)<BR><BR>So, now, how do you define "highest possible values"???<BR><BR>If it is the *sum* of x+y+z, then of course it is always 1000.<BR><BR>But...<BR><BR>I hope you recognize that my arbitrary choices for the values *do not matter*. No matter what values you give me for all those U0,U1,U2,U3,P1,P2,P3 there will be an infinite number of combinations of x,y,z that satisfy the equation.<BR><BR><BR>

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•