Expression fields referencing other expression fields. Shown vs Not Shown leading to issues.

[black272]

I have multiple expression fields. Some of the expression fields reference some of the other expression fields. When I have all expression fields "Shown" button selected the resulting query works fine. The issue is I want to hide some of the expression fields as they are only used as placeholders. When I de-select the Show button on the fields, and try and run the query, I get an alert asking me to enter parameters for the (now not shown) field. How can I hide these expression fields?

Placeholder1: Replace([CandyName],"Cherry Bomb","Bazooka Gum").... Show 'deselected'

NewName: Replace([Placeholder1],"Bazooka Gum","Big League Chew")... Show 'selected'

[davegri]

Simply showing values you put in controls doesn't help at all. You're using 3 terms describing your desired result ("Show, Select, Hide").
Can you describe the problem in terms of what you want to happen and what you have tried so far, showing code method used?

[Gicu]

I think you need to leave the "placeholder" fields having the Show check-box checked, run the query and in datasheet view right click on each field you want to hide and click on Hide. Now save your query and it should open like that next time.

Cheers,

[black272]

Sorry, I'm somewhat new to access and have little SQL background so I'll do my best to clearly explain my problem. Essentially I dont want to show a column but Access is asking for parameters when I Hide the column.

More specifically:

I have a large table that I'm running a query on. Many of the tables data and field names need to be renamed, but they cant be renamed in the table, thus Im making expressions to rename them.

Renaming the field names seem to be easy enough. Renaming the data has been more difficult. Many of the data requires iif statements for renaming. Im not sure how to create many unique iif statements in one builder/field so I've had to create multiple fields with single iff statements.

For example field [A] has data x, y, z. The data has to be renamed to a, b, c, where x = a, y = b, z = c. However its not as simple as nested replace function as I mentioned above. Specifically to rename x to a, conditions must be met (for example a data point in a different field must be present). To rename y to b different conditions must be met, etc.

This has led to me to creating new fields where each condition is treated on its own. Because of this, the final query doesnt need to show many of the fields because theyre just needed to calculate another field. Id like to hide most of these fields in the final query, but as soon as I do, Access ask for parameters.



Sorry if this doesnt make much sense

[black272]

This was the answer. Thank you!

[Gicu]

Happy New Year!