Expr1 being asked for when query run

[Ralph]

Hi All,

Everytime I run a query that I have created it asks me to input Expr1 and Expr2 in an enter perameter value pop up box. I don't enter anything, just click okay and the query runs as expected.

Is there a way to get rid of these? (and maybe more importantly, why do they appear?)

Any help greatly appreciated.

Ralph

 

[Alansidman]

Look at your query in design view. I am guessing that you probably changed something in a table design after the query was built and when you run the query, there are former field names that Access cannot identify and this its way of telling you.

 

[Ralph]

Thanks!

I'll go and check.......

 

[Ralph]

I really cannot find anything that fits the bill.

I have 3 expressions that prompt the parameter query box to appear on various queries and reports:

An example of one:

Expr2: Round([New Licence Fee Amount]/30.42,2)

This is a calculated field in a query.

Any thoughts?

 

[Brianwarnock]

Can you post the full SQL, does expr2 appear anywhere else?

Brian

 

[MSAccessRookie]

I really cannot find anything that fits the bill.

I have 3 expressions that prompt the parameter query box to appear on various queries and reports:

An example of one:

Expr2: Round([New Licence Fee Amount]/30.42,2)

This is a calculated field in a query.

Any thoughts?

Is your Main Query looking for Fields named Expr1 or Expr2? If not, then you also said "This is a calculated field in a query". Since the Sub-Query has not been displayed, perhaps the missing Expressions are in the Sub-Query, and not the Main Query. Run the Sub-Query and see if it has Fields named Expr1, Expr2, or the like. If it does, then you need to fix the Sub Query.

Remember that although any Query can be used like a Table, when you do, any error will look like it is a part of the outermost Query.

-- Rookie

 

[Ralph]

Erm... I think maybe i've made a hash of the whole thing rather. Very much new to this and have fumbled my way thus far using expression builder and macro builder, without really understanding everything that is going on.

I have queries that draw on information from other queries.

I know where expr1 and expr2 first appear -they are in a query that draws it's information from two tables. The first five fields in this query take information directly from the tables, then the next two fields calculate something using information from the tables (Access has automatically named these expr1 and expr2) and the final field performs a calculation based on fields 6 & 7.

Clear as mud?

 

[Ralph]

I have sorted it.... I think.

It seems that where I was calculating something in a query field - Access would allocate a name to it (Expr1 or similar) which is fine, but if I try to use that name in a calculation in another field in the same query, Access does not accept it.

Sound at all right?

I have changed the fields to calculate without using the other fields in the same query and it seems to work okay??


Thanks for all the help!!!

 

[Brianwarnock]

Sound at all right?

No Access will happily let you do E.G. Expr1-Expr2 or Expr1/Expr2

You never did post your SQL as requested so we could only provide limited help, still you are are happy now.

Brian