I cannot use a query in a query criteria, it asks me for a parameter instead

[muhammad]

Hello, I have a problem that when I enter a value from another query in a query criteria instead of using the value of the criteria it asks for a parameter, here's a picture: first part of the criteria, second part of the criteria, The value from the original query used in the second one, when I run the query I need to additionally say that it works in a different database but I don't know why it works there but not in this database. Thanks a lot for anyone who helps.

[mike60smart]

Hi
Can you post a screenshot of the Query Builder windows showing the tables & Relationships?

[Welshgasman]

Hi
Can you post a screenshot of the Query Builder windows showing the tables & Relationships?

Can you post pics on your very first post?

Please post the code of the query within code tags and tell us what parameter the query is asking for.

[mike60smart]

Sorry Forgot about that limitation.

[June7]

Many prefer not to download files from external site. Should be able to embed images in post, otherwise put them in a zip folder with Windows Compression and attach to your post.
Post the SQL statement as formatted code.
You could even go to Advanced post editor and build tables of sample data.

Or better, provide db for analysis, follow instructions at bottom of my post.

[muhammad]

Here are the images you've asked for:(It asked for the parameter "Max of time!MaxOfTime")



The query code:

SELECT tblWorkers.FirstName, tblWorkers.LastName, tblWorkers.TimeFROM (((tblBusses INNER JOIN tblCities ON tblBusses.CityID = tblCities.CityID) INNER JOIN tblHistory ON tblBusses.BusID = tblHistory.BusID) INNER JOIN tblWorkers ON (tblWorkers.WorkerID = tblHistory.WorkerID) AND (tblCities.CityID = tblWorkers.CityID) AND (tblBusses.BusID = tblWorkers.BusID)) INNER JOIN tblStation ON (tblStation.StationID = tblWorkers.StaionID) AND (tblStation.StationID = tblHistory.StationID) AND (tblCities.CityID = tblStation.CityID)
WHERE (((tblWorkers.Time)=[Max of time]![MaxOfTime]));

[muhammad]

I've replied with the information you asked if you could take a look

[mike60smart]

Hi
Remove the criteria you currently have in the query.

Then click the Totals Button on the Ribbon Menu.

Then set the criteria for the "Time" field to "Max"

[mike60smart]

I would also suggest that you only need the tblWorkers in the query.

Delete all none required tables

[muhammad]

Hi
Remove the criteria you currently have in the query.

Then click the Totals Button on the Ribbon Menu.

Then set the criteria for the "Time" field to "Max"

I know but is there a way to make it work when it uses the value from another query? because I will need the use of other queries in the criteria.

[mike60smart]

We can't see the data in your tables so it would help if you can explain your database process to us.

From the relationships shown in the query it looks like you are recording details about Workers use of Busses?? Please explain.

[Micron]

is there a way to make it work when it uses the value from another query?

IMO, only via subquery (where [Max of time] value is retrieved) OR include the query in the design grid and add that field from that query. Your issue is that the query has no idea where to get the value from - it cannot do some sort of lookup just because you designed it without including the query as one of the table sources.