By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,482 Members | 2,107 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,482 IT Pros & Developers. It's quick & easy.

Nested Quiriers ??

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 13 '05 #2

P: n/a
"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
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.