HOw to prevent Access Mucking up my formulas!

  • Thread starter Thread starter Phil Smith
  • Start date Start date
P

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
 
Phil said:
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
Click to expand...

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.
 
Back
Top