CODEWITHSUNDEEP
databasems-access
Lara
Lara

Reputation: 3021

MS access query List

I am working on a MS access query optimization because, it is taking long time to run and sometimes it is giving the response and sometimes not. While drill down the entire query I got this line 

qry List at tbl at AGENT_STAFF Active MAX END DATE

Which when I tried to run separately, its not able to run. I need to understand this line and know how to run this.

Upvotes: 0

Views: 131

Answers (1)

Andre
Andre

Reputation: 27634

Parts in square brackets, like

LEFT JOIN [qry List at tbl at AGENT_STAFF Active MAX END DATE]

are object names (tables, queries or field names).

So you'll need to analyze the subquery in the join.

Upvotes: 1

Related Questions