Unwanted "Enter Parameter Value" Box

[molly13]

Hi,



I have a query with several different columns. One Column, CodeNum is built based on the values in Expr4. When I try to set a criteria for CodeNum (Like "8*"), and I run the query, I get a popup for Expr4 ("Enter Parameter Value | Expr4). Is there any way to correct for this problem? I want to get all values of Expr4 when CodeNum starts with an 8.

CodeNum is built as follows: JCC: Left([Expr4],InStr([Expr4],"/")-1)

Thank you very much!

[ranman256]

1st, rename the label EXPR4 to something usefull., like MyValue. (just type over it)

2. If EXPR4 is a calc, EXPR4: [radius]*3.14, then you CANT use expr4 here in the same query. You must use the calc again,at query time, EXPR4 doesnt exist yet, so Access is asking for an answer.
OR
make a query FROM THAT query ,THEN you can use EXPR4.

[molly13]

Hi - thank you very much, that is very helpful.

I have now nested the calculation for "EXPR4" into the JCC field (so that EXPR4 doesn't exist anymore), but I get the error "The text is too long to be edited." Is there a way around this that wouldn't involve creating another query (as I would need several different queries, not just one additional)?

Thank you.

[ranman256]

Hmm. Not sure on that. You may have to alter the calc.
Can you put more calcs in the 1st query without the need for the 2nd. (sorta put all calcs in 1 line.)