Nested Quiriers ??

[Rashrashetta]

Dear all,

I need to know how to create nested query in MS access ??
Please provide me with any link that may help as soon as possible.
Thanx alot,
Rashrashetta

[Bas Cost Budde]

Rashrashetta wrote:

Dear all,

I need to know how to create nested query in MS access ??
Please provide me with any link that may help as soon as possible.

What do you term "nested queries"? you can save any query, and use that
in another query as if it were a table. Providing it returns records,
that is.

If you mean recursive queries, brace for impact. Access doesn't do that.

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea

[Larry Linson]

"Rashrashetta" wrote

I need to know how to create
nested query in MS access ??
Please provide me with any link
that may help as soon as possible.

In the simplest case, you create a Query then you use that Query (or
multiple Queries you have created) as data source for a new Query... this
can all be done in the Query Builder.

If you mean "subqueries", that is, the SQL for one Query "spelled out"
inside the SQL for another Query, then you need to be more specific in your
question.

If my answer leads you to believe there were implications to your question
that were not apparent to me, please post back to clarify. Perhaps with more
information, someone can be more specific.

Larry Linson
Microsoft Access MVP