Why am i being asked for a parameter

[chrisjames25]

Hi

JHB has kindly been helping me to solve a query issue i am having. I have tried to solve the last piece of puzzle myself and have got close however i am a bit confused with one element.

I have created a query in query design using various expressions and when i click run it asks me to enter a parameter for various things. I simply click enter enter enter to tab through them and then query displays as i want but i have no oidea why asking me to enter a parameter and how to stop it occurgin

Attached smaple database. Query 6 is the offending query.

Cheers

 

[plog]

Because [available] is not a field in any of the data sources your query is built on. You can't define the field and immediately use it in the same query. To use [available] you would need to build Query7 and then it would be (for lack of a better term) available.

With that said, Query6 isn't structured properly. Your data sources shouldn't be in a circular relationship with one another. You should only be able to trace 1 path between data sources--in Query6 you can go clockwise and counter clockwise to travel data sources--that is incorrect. Further, life will be easier for you if you eliminate spaces in field names.

 

[isladogs]

The parameters are caused by you using expressions & grouping at the same time.
Access doesn't know what to do first so flags up using parameters

I've redone this as:
a) query6A without grouping - I've also removed an extra unwanted link
b) query7 - this is query6A grouped
Result - no parameter warnings

See attached

EDIT - just read plog's reply - great minds (and mine) think alike