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

import+3query+recursion

P: n/a
i have a mdb which imports file from excel(specified directory) into
access. once in access i have to run a self query/union query within one
table. can i do something so that the query becomes recursive...it picks
values from the access table(converted from the excel file), one-by-one and
keeps running the query?
i know its a big question, but i also know, there are lot of educated and
helping people. i would be very oblidged, if someone could help.i am very
new to all this.
i can go into details, if required.
regards.

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Um, I don't think queries can be recursive in the genuine sense - there's
no procedural sort of loops or steps for a query that you could recurse
through, but you're actually defining a value or field - so you'd end up
with a circular reference that cannot be calculated, much like a circular
Excel formula.

Having said that, you could have a query that updates values in a given
table that you could run multiple times using VBA code - you'd have to
figure out how to terminate the loop, though.

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.