Expession Field

[TeeSee]

Access 2003. This post is along the same lines as my last but a
different approach.????

Is it possible, on the query grid, to create an expression field based
on a calculated field but convert it to a number format for lookup/
criterion setting purposes?

 

[John W. Vinson]

Access 2003. This post is along the same lines as my last but a
different approach.????

Is it possible, on the query grid, to create an expression field based
on a calculated field but convert it to a number format for lookup/
criterion setting purposes?

Yes, for example using the Val() function.

For a more detailed answer post a more detailed question.

John W. Vinson [MVP]

 

[TeeSee]

Yes, for example using the Val() function.

For a more detailed answer post a more detailed question.

             John W. Vinson [MVP]

I have a calculated field that uses other calculated fields to come up
with its value. What I would like to achieve is to use the Val()
function to reduce this one field named "Markup" to a value in order
that I can set criteria (< .25)eg without going throo the arduous task
of entering all the formulae for each of the calculated fields. All
calculated fields are in the same query. I only desire to do this in
the query grid.

Thanks for the response.

 

[John W. Vinson]

I have a calculated field that uses other calculated fields to come up
with its value. What I would like to achieve is to use the Val()
function to reduce this one field named "Markup" to a value in order
that I can set criteria (< .25)eg without going throo the arduous task
of entering all the formulae for each of the calculated fields. All
calculated fields are in the same query. I only desire to do this in
the query grid.

It's often impossible to base a calculated expression on other calculated
expressions (because the query optimizer can't figure out which calculation to
do first). You may just be stuck recapitulating the individual calculations!

Why not just calculate Markup as a value in the first place? Perhaps you could
post the expression you're now using, maybe someone can suggest how to
simplify it.

John W. Vinson [MVP]