Simple Expression Too Complex

**XMVP** · Nov 13 '05, 01:40 AM

Re: Simple Expression Too Complex

"Dr. Paul Bremmer, PhD" <PaulBremmer@ha rvard.edu> wrote in message
news:hGqFc.4385 6$t55.1466864@w agner.videotron .net...[color=blue]
> Dear Access experts:
>
> Access is returning the error, "Expression too complex," despite only[/color]
entering[color=blue]
> an absurdly simple math function. Is there a way to simplify this any[/color]
further,[color=blue]
> or perhaps augment the Access execution limits?
>
> ( ( ( z - ( z ^ ( ( ( ( 3 + c ) + x ) + 3 ) ^ ( ( ( ( i - ( y* x ) )* ( 7*[/color]
( ([color=blue]
> b/ ( z - ( a - z ) ) ) ^ ( ( ( x - z ) ^ ( ( ( ( ( ( x ^ ( ( 7* ( ( 4 -[/color]
i ) - ([color=blue]
> 4 - ( ( y* x )* y ) ) ) ) + ( ( y/ ( y + ( ( ( 4 - 3 )* c )/ ( ( b/ z ) -[/color]
i ) )[color=blue]
> ) )/ ( c/ ( y* ( ( ( 5 + ( ( ( 73 + ( ( ( 4* y )* 7 ) ^ ( ( ( ( 9 ^ i )/[/color]
c ) -[color=blue]
> y ) ^ y ) ) )* z ) - ( 6/ ( e* ( a + ( ( z/ ( ( i + pi ) ^ ( ( ( ( 3/ ([/color]
z - i )[color=blue]
> ) + ( 9/ ( ( y/ 5 )* ( y + ( y + ( 8 + ( y/ x ) ) ) ) ) ) )* 4 ) -[/color]
7 ) ) ) - a[color=blue]
> ) ) ) ) ) )/ ( e* ( ( 5/ ( ( 6/ a )/ z ) ) + 36 ) ) )/ ( ( ( z ^ 9 ) +[/color]
i )/ x )[color=blue]
> ) ) ) ) ) )/ 2 ) - 8 ) - 8 ) - ( ( ( z - ( ( ( ( i/ 4 ) + ( a* 6 ) ) ^[/color]
e )* ( 8[color=blue]
> ^ y ) ) ) - ( x ^ y ) ) ^ ( y - 7 ) ) ) ^ a ) )/ ( ( ( a* z )* b ) -[/color]
z ) ) ) )[color=blue]
> ) - ( a + ( b + ( ( i + b ) - ( ( y/ 6 ) + a ) ) ) ) ) + pi ) ) ) )/ ( ( e[/color]
^ ([color=blue]
> z/ ( 9 + ( 2 - 8 ) ) ) ) + a ) )/ 5 )
>
> Thank you kindly,
>
> Paul Bremmer, PhD
> Harvard University
>[/color]

You can augment the Access execution limits only by becoming an MVP. Or you
can simplify the expression by removing the unneeded pair of parenthesis, as
indicated below:

( ( ( z - ( z ^ ( ( ( ( 3 + c ) + x ) + 3 ) ^ ( ( ( ( i - ( y* x ) )* ( 7*
( (
b/ ( z - ( a - z ) ) ) ^ ( ( ( x - z ) ^ ( ( ( ( ( ( x ^ ( ( 7* ( ( 4 -
i ) - (
4 - ( ( y* x )* y ) ) ) ) + ( ( y/ ( y + ( ( ( 4 - 3 )* c )/ ( ( b/ z ) -
i ) )
) )/ ( c/ ( y* ( ( ( 5 + ( ( ( 73 + ( ( ( 4* y )* 7 ) ^ ( ( ( ( 9 ^ i )/
c ) -
y ) ^ y ) ) )* z ) - ( 6/ ( e* ( a + ( ( z/ ( ( i + pi ) ^ ( ( ( ( 3/ ( z -
i )
) + ( 9/ ( ( y/ 5 )* ( y + ( y + ( 8 + ( y/ x ) ) ) ) ) ) )* 4 ) - 7 ) ) ) -
a
) ) ) ) ) )/ ( e* ( ( 5/ ( ( 6/ a )/ z ) ) + 36 ) ) )/ ( ( ( z ^ 9 ) + i )/
x )
) ) ) ) ) )/ 2 ) - 8 ) - 8 ) - ( ( ( z - ( ( ( ( i/ 4 ) + ( a* 6 ) ) ^ e )*
( 8
^ y ) ) ) - ( x ^ y ) ) ^ ( y - 7 ) ) ) ^ a ) )/ ( ( ( a* z )* b ) -
z ) ) ) )
) - ( a + ( b + ( ( i + b ) - ( ( y/ 6 ) + a ) ) ) ) ) + pi ) ) ) )/ ( ( e ^
(
z/ ( 9 + ( 2 - 8 ) ) ) ) + a ) )/ 5 )

**PC Datasheet** · Nov 13 '05, 01:40 AM

Re: Simple Expression Too Complex

<< Is there a way to simplify this any further >>

E = MC2

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

and ABSURDLY SIMPLE MATH FUNCTIONS

resource@pcdata sheet.com

https://www.pcdatasheet.com

"Dr. Paul Bremmer, PhD" <PaulBremmer@ha rvard.edu> wrote in message
news:hGqFc.4385 6$t55.1466864@w agner.videotron .net...[color=blue]
> Dear Access experts:
>
> Access is returning the error, "Expression too complex," despite only entering
> an absurdly simple math function. Is there a way to simplify this any[/color]
further,[color=blue]
> or perhaps augment the Access execution limits?
>
> ( ( ( z - ( z ^ ( ( ( ( 3 + c ) + x ) + 3 ) ^ ( ( ( ( i - ( y* x ) )* ( 7* ( (
> b/ ( z - ( a - z ) ) ) ^ ( ( ( x - z ) ^ ( ( ( ( ( ( x ^ ( ( 7* ( ( 4 - i ) -[/color]
([color=blue]
> 4 - ( ( y* x )* y ) ) ) ) + ( ( y/ ( y + ( ( ( 4 - 3 )* c )/ ( ( b/ z ) -[/color]
i ) )[color=blue]
> ) )/ ( c/ ( y* ( ( ( 5 + ( ( ( 73 + ( ( ( 4* y )* 7 ) ^ ( ( ( ( 9 ^ i )/ c ) -
> y ) ^ y ) ) )* z ) - ( 6/ ( e* ( a + ( ( z/ ( ( i + pi ) ^ ( ( ( ( 3/ ( z -[/color]
i )[color=blue]
> ) + ( 9/ ( ( y/ 5 )* ( y + ( y + ( 8 + ( y/ x ) ) ) ) ) ) )* 4 ) - 7 ) ) ) - a
> ) ) ) ) ) )/ ( e* ( ( 5/ ( ( 6/ a )/ z ) ) + 36 ) ) )/ ( ( ( z ^ 9 ) + i )/[/color]
x )[color=blue]
> ) ) ) ) ) )/ 2 ) - 8 ) - 8 ) - ( ( ( z - ( ( ( ( i/ 4 ) + ( a* 6 ) ) ^ e )*[/color]
( 8[color=blue]
> ^ y ) ) ) - ( x ^ y ) ) ^ ( y - 7 ) ) ) ^ a ) )/ ( ( ( a* z )* b ) - z ) ) ) )
> ) - ( a + ( b + ( ( i + b ) - ( ( y/ 6 ) + a ) ) ) ) ) + pi ) ) ) )/ ( ( e ^ (
> z/ ( 9 + ( 2 - 8 ) ) ) ) + a ) )/ 5 )
>
> Thank you kindly,
>
> Paul Bremmer, PhD
> Harvard University
>[/color]

**WindAndWaves** · Nov 13 '05, 01:40 AM

Re: Simple Expression Too Complex

Dear Paul

You make me laugh! Absurdly simple you say. Do you have any idea what
simple means????

I am sure that access can do your math function, but if I was you then I
would break it down into several parts and steps. Now you need to look for
a needle in a haystack. If you break it down, you will also sharply reduce
the chance of making a typo. That is, you can test and check each
individual part of your expression.

Regards

- Nicolaas

**E.G. Barns** · Nov 13 '05, 01:40 AM

Re: Simple Expression Too Complex

"Dr. Paul Bremmer, PhD" <PaulBremmer@ha rvard.edu> wrote in message
news:hGqFc.4385 6$t55.1466864@w agner.videotron .net...[color=blue]
> Dear Access experts:
>
> Access is returning the error, "Expression too complex," despite only[/color]
entering[color=blue]
> an absurdly simple math function. Is there a way to simplify this any[/color]
further,[color=blue]
> or perhaps augment the Access execution limits?
>
> ( ( ( z - ( z ^ ( ( ( ( 3 + c ) + x ) + 3 ) ^ ( ( ( ( i - ( y* x ) )* ( 7*[/color]
( ([color=blue]
> b/ ( z - ( a - z ) ) ) ^ ( ( ( x - z ) ^ ( ( ( ( ( ( x ^ ( ( 7* ( ( 4 -[/color]
i ) - ([color=blue]
> 4 - ( ( y* x )* y ) ) ) ) + ( ( y/ ( y + ( ( ( 4 - 3 )* c )/ ( ( b/ z ) -[/color]
i ) )[color=blue]
> ) )/ ( c/ ( y* ( ( ( 5 + ( ( ( 73 + ( ( ( 4* y )* 7 ) ^ ( ( ( ( 9 ^ i )/[/color]
c ) -[color=blue]
> y ) ^ y ) ) )* z ) - ( 6/ ( e* ( a + ( ( z/ ( ( i + pi ) ^ ( ( ( ( 3/ ([/color]
z - i )[color=blue]
> ) + ( 9/ ( ( y/ 5 )* ( y + ( y + ( 8 + ( y/ x ) ) ) ) ) ) )* 4 ) -[/color]
7 ) ) ) - a[color=blue]
> ) ) ) ) ) )/ ( e* ( ( 5/ ( ( 6/ a )/ z ) ) + 36 ) ) )/ ( ( ( z ^ 9 ) +[/color]
i )/ x )[color=blue]
> ) ) ) ) ) )/ 2 ) - 8 ) - 8 ) - ( ( ( z - ( ( ( ( i/ 4 ) + ( a* 6 ) ) ^[/color]
e )* ( 8[color=blue]
> ^ y ) ) ) - ( x ^ y ) ) ^ ( y - 7 ) ) ) ^ a ) )/ ( ( ( a* z )* b ) -[/color]
z ) ) ) )[color=blue]
> ) - ( a + ( b + ( ( i + b ) - ( ( y/ 6 ) + a ) ) ) ) ) + pi ) ) ) )/ ( ( e[/color]
^ ([color=blue]
> z/ ( 9 + ( 2 - 8 ) ) ) ) + a ) )/ 5 )
>
> Thank you kindly,
>
> Paul Bremmer, PhD
> Harvard University
>[/color]

What version of Access are you using? I only use Access 97 and it runs
the expression just fine.

**John Winterbottom** · Nov 13 '05, 01:40 AM

Re: Simple Expression Too Complex

"Dr. Paul Bremmer, PhD" <PaulBremmer@ha rvard.edu> wrote in message
news:hGqFc.4385 6$t55.1466864@w agner.videotron .net...[color=blue]
> Dear Access experts:
>
> Access is returning the error, "Expression too complex," despite only[/color]
entering[color=blue]
> an absurdly simple math function. Is there a way to simplify this any[/color]
further,[color=blue]
> or perhaps augment the Access execution limits?
>
> ( ( ( z - ( z ^ ( ( ( ( 3 + c ) + x ) + 3 ) ^ ( ( ( ( i - ( y* x ) )* ( 7*[/color]
( ([color=blue]
> b/ ( z - ( a - z ) ) ) ^ ( ( ( x - z ) ^ ( ( ( ( ( ( x ^ ( ( 7* ( ( 4 -[/color]
i ) - ([color=blue]
> 4 - ( ( y* x )* y ) ) ) ) + ( ( y/ ( y + ( ( ( 4 - 3 )* c )/ ( ( b/ z ) -[/color]
i ) )[color=blue]
> ) )/ ( c/ ( y* ( ( ( 5 + ( ( ( 73 + ( ( ( 4* y )* 7 ) ^ ( ( ( ( 9 ^ i )/[/color]
c ) -[color=blue]
> y ) ^ y ) ) )* z ) - ( 6/ ( e* ( a + ( ( z/ ( ( i + pi ) ^ ( ( ( ( 3/ ([/color]
z - i )[color=blue]
> ) + ( 9/ ( ( y/ 5 )* ( y + ( y + ( 8 + ( y/ x ) ) ) ) ) ) )* 4 ) -[/color]
7 ) ) ) - a[color=blue]
> ) ) ) ) ) )/ ( e* ( ( 5/ ( ( 6/ a )/ z ) ) + 36 ) ) )/ ( ( ( z ^ 9 ) +[/color]
i )/ x )[color=blue]
> ) ) ) ) ) )/ 2 ) - 8 ) - 8 ) - ( ( ( z - ( ( ( ( i/ 4 ) + ( a* 6 ) ) ^[/color]
e )* ( 8[color=blue]
> ^ y ) ) ) - ( x ^ y ) ) ^ ( y - 7 ) ) ) ^ a ) )/ ( ( ( a* z )* b ) -[/color]
z ) ) ) )[color=blue]
> ) - ( a + ( b + ( ( i + b ) - ( ( y/ 6 ) + a ) ) ) ) ) + pi ) ) ) )/ ( ( e[/color]
^ ([color=blue]
> z/ ( 9 + ( 2 - 8 ) ) ) ) + a ) )/ 5 )
>[/color]

Access 2003:-

Sub testInsanelyCom plicatedExpress ion()

Dim a, b, c, e, i, x, y, z, answer As Double

Const pi = 3.141592657

a = 0.1
b = 0.2
c = 0.3
e = 0.4
i = 0.5
x = 0.6
y = 0.7
z = 0.8

answer = (((z - (z ^ ((((3 + c) + x) + 3) ^ ((((i - (y * x)) * (7 * (( _
b / (z - (a - z))) ^ (((x - z) ^ ((((((x ^ ((7 * ((4 - i) - ( _
4 - ((y * x) * y)))) + ((y / (y + (((4 - 3) * c) / ((b / z) - i)) _
)) / (c / (y * (((5 + (((73 + (((4 * y) * 7) ^ ((((9 ^ i) / c) - _
y) ^ y))) * z) - (6 / (e * (a + ((z / ((i + pi) ^ ((((3 / (z - i) _
) + (9 / ((y / 5) * (y + (y + (8 + (y / x))))))) * 4) - 7))) - a _
)))))) / (e * ((5 / ((6 / a) / z)) + 36))) / (((z ^ 9) + i) / x) _
)))))) / 2) - 8) - 8) - (((z - ((((i / 4) + (a * 6)) ^ e) * (8 _
^ y))) - (x ^ y)) ^ (y - 7))) ^ a)) / (((a * z) * b) - z)))) _
) - (a + (b + ((i + b) - ((y / 6) + a))))) + pi)))) / ((e ^ ( _
z / (9 + (2 - 8)))) + a)) / 5)

Debug.Print answer

End Sub

Gives me divide by zero error. So at least it's evaluating the expression.
If you supply values for your variables and tell us what the correct answer
is maybe we can help a bit more.

**Dr. Paul Bremmer, PhD** · Nov 13 '05, 01:41 AM

Re: Simple Expression Too Complex

In article <02f22f4dd7fc67 47f7667161a6e65 c8b@news.terane ws.com>,
NotSpam@SpamNot .net says...[color=blue]
>
>
>"Dr. Paul Bremmer, PhD" <PaulBremmer@ha rvard.edu> wrote in message
>news:hGqFc.438 56$t55.1466864@ wagner.videotro n.net...[color=green]
>> Dear Access experts:
>>
>> Access is returning the error, "Expression too complex," despite only[/color]
>entering[color=green]
>> an absurdly simple math function. Is there a way to simplify this any[/color]
>further,[color=green]
>> or perhaps augment the Access execution limits?
>>
>> ( ( ( z - ( z ^ ( ( ( ( 3 + c ) + x ) + 3 ) ^ ( ( ( ( i - ( y* x ) )* ( 7*[/color]
>( ([color=green]
>> b/ ( z - ( a - z ) ) ) ^ ( ( ( x - z ) ^ ( ( ( ( ( ( x ^ ( ( 7* ( ( 4 -[/color]
>i ) - ([color=green]
>> 4 - ( ( y* x )* y ) ) ) ) + ( ( y/ ( y + ( ( ( 4 - 3 )* c )/ ( ( b/ z ) -[/color]
>i ) )[color=green]
>> ) )/ ( c/ ( y* ( ( ( 5 + ( ( ( 73 + ( ( ( 4* y )* 7 ) ^ ( ( ( ( 9 ^ i )/[/color]
>c ) -[color=green]
>> y ) ^ y ) ) )* z ) - ( 6/ ( e* ( a + ( ( z/ ( ( i + pi ) ^ ( ( ( ( 3/ ([/color]
>z - i )[color=green]
>> ) + ( 9/ ( ( y/ 5 )* ( y + ( y + ( 8 + ( y/ x ) ) ) ) ) ) )* 4 ) -[/color]
>7 ) ) ) - a[color=green]
>> ) ) ) ) ) )/ ( e* ( ( 5/ ( ( 6/ a )/ z ) ) + 36 ) ) )/ ( ( ( z ^ 9 ) +[/color]
>i )/ x )[color=green]
>> ) ) ) ) ) )/ 2 ) - 8 ) - 8 ) - ( ( ( z - ( ( ( ( i/ 4 ) + ( a* 6 ) ) ^[/color]
>e )* ( 8[color=green]
>> ^ y ) ) ) - ( x ^ y ) ) ^ ( y - 7 ) ) ) ^ a ) )/ ( ( ( a* z )* b ) -[/color]
>z ) ) ) )[color=green]
>> ) - ( a + ( b + ( ( i + b ) - ( ( y/ 6 ) + a ) ) ) ) ) + pi ) ) ) )/ ( ( e[/color]
>^ ([color=green]
>> z/ ( 9 + ( 2 - 8 ) ) ) ) + a ) )/ 5 )
>>
>> Thank you kindly,
>>
>> Paul Bremmer, PhD
>> Harvard University
>>[/color]
>
>What version of Access are you using? I only use Access 97 and it runs
>the expression just fine.[/color]

I use Access 2003. Why would you drive a Model T when a Ferrari is available?

**Tom van Stiphout** · Nov 13 '05, 01:45 AM

Re: Simple Expression Too Complex

On Sat, 03 Jul 2004 17:05:59 GMT, PaulBremmer@har vard.edu (Dr. Paul
Bremmer, PhD) wrote:

Is that why you're hiding behind teranews, a known anonymizer?
And you're driving a 16-bit news reader????

Folks, we're witnessing the birth of another troll.

-Tom.

<clip>
[color=blue]
>I use Access 2003. Why would you drive a Model T when a Ferrari is available?[/color]

**Tony Toews** · Nov 13 '05, 01:45 AM

Re: Simple Expression Too Complex

PaulBremmer@har vard.edu (Dr. Paul Bremmer, PhD) wrote:
[color=blue]
>Message-ID: <hGqFc.43856$t5 5.1466864@wagne r.videotron.net >
>X-Complaints-To: abuse@videotron .ca
>X-Trace: wagner.videotro n.net[/color]

We've seen this NNTP server name before.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at

Tony's Main Microsoft Access Page

http://www.granite.ab.ca/accsmstr.htm

Tony's Microsoft Access Hint's, Tips and FAQ

**Larry Linson** · Nov 13 '05, 01:45 AM

Re: Simple Expression Too Complex

"Tom van Stiphout" wrote
[color=blue]
> Folks, we're witnessing the birth of another troll.[/color]

Same troll, different sockpuppet names.

Simple Expression Too Complex

Simple Expression Too Complex

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment