Link queries

[Crookshanks]

Goodafternoon,

Is it possible to link queries like you can do with tables (create link)? If yes, how should I start.

Kind regards and thanks in advance,

 

[THWatson]

Crookshanks
Assuming there is some relatable field in each query to create the link, you can drag both queries into a new query grid and make the join there.

If there isn't a relatable field then you can join the information from the queries by using a Union query.

It depends upon exactly what you wish to accomplish.

Tom

 

[Crookshanks]

As it seems impossible to use an external query (other database) to populate a report I was wondering If I could let the query behave like it was in the actual database itself as you can do with linked tables.