Query Parameter --maybe not

[alansidman]

I am generating a group of queries that require expressions that do not have to be visible in the results. In setting up the expressions, I have given them an alias by replacing the Expr1: with a rational name such as Adj Field. When I unclick the box to show the "Adj Field" in the query results, Access deletes it from the Expression box and I am left with only the formula(expression). I have a second Expression that is visible and relies on the first Expression, using the alias 'Adj Field' in the second expression. When I click on the run Query, I get a parameter like box that appears to be looking for input -- the paramter like box has the "Adj Field" above the input area.

What can I do to fix this? Eliminate the parameter like box and still maintain the alias in the expression. Am I over reaching. I would think that this would be possible but not sure how to solve the issue short of having extraneous information presented in the query results.

Thanks much
Alan

 

[Joe4]

Yes, I have run into that problem from time to time also. Access does not seem to like it if you have nested calculations in a query, and one of the underlying calculations is not visible.

Here are a few methods I used to get around it.

1. Make all the underlying calculations visible. If the end result is a Form or Report, you don't need to show it there, so it shouldn't matter if it is visible in the Query.

2. If your end result is the Query or an Export, you could always created another query that uses this query as its source and only display the fields you want (so what you really have is an underlying "calculation" query and a final "results" query).

 

[alansidman]

Thanks Joe;
I will try to do that.
Alan

 

[alansidman]

Hey Joe;
Just made the first one as you described and it was very slick. I've been killing myself on this for a couple of days because it has some parameter features that the EU needs to complete at the run request time. This makes it work great. Thank you.

 

[Joe4]

Glad to help!