Internal vs. External Queries

[Heatshiver]

I am not sure if the terms I am using are correct but I'll explain what I mean.

Internal Query: A query that is built-in to a form or report. It does not display under the list of queries on the right side and can therefore not be referenced for other forms or reports.

External Query: A query that can be referenced for any form or report. It does display under the list of queries on the right. The more common of the two.

I am wondering what are the benefits and downsides of the two. I know one benefit to external queries is that I can have multiple forms or reports reference the same query if the fields are the same.

 

[mahenkj2]

Even I would like to know the same. Also, all experts at some point of time recommend to use queries for forms not the tables. What if I select a table in the recordsource and just invoke the query builder and then select all the field. Anyway, it will then become a select statement. Is it as good as selecting a already built "External query" as you named in your post.

Just request experts their comments.