HOw to prevent Access Mucking up my formulas!

[Phil Smith]

I am looking at a formula that I wrote that begins Sum(...

Problem Is, I NEVER PUT that at the beginning my formula. MY Formula
started with IIF(...

Access rewrote my formula. While technically, this new version should
operate the same way, in point of fact it does not.

Is there anyway to have Acces keep it's dirty rotten mitts OFF my
formulas, and keep them as I enter them?

Phil

 

[Rick Brandt]

I am looking at a formula that I wrote that begins Sum(...

Problem Is, I NEVER PUT that at the beginning my formula. MY Formula
started with IIF(...

Access rewrote my formula. While technically, this new version should
operate the same way, in point of fact it does not.

Is there anyway to have Acces keep it's dirty rotten mitts OFF my
formulas, and keep them as I enter them?

Phil

In a query? No. They are optimized when saved and that often means changing
various aspects of the actual SQL. Nearly all the time the result is the
same as what you wrote only it runs faster.

Only passthrough queries are left completely as you type them.