Query-query dependancies

[tatamata]

Hi!
I have a lot of queries that are based on other queries, which are based on
some other queries, etc... Quite a mess!
I would like to simplify SQL of the top queries so that they are based only
on tables, not other queries. It would be too complicated and time-consuming
to do it manually, so I'm wondering if there is some commercial or free tool
that can make it automatically? It would save me lot of time and nerves...
I suppose that Access do something like that internally, right?

Thanks,

Zlatko

 

[Roger Carlson]

Take a look at Rick Fisher's "Find and Replace". You can download it here:
http://www.rickworld.com/download.html. If you pay the reasonable
registration fee, you get added functionality that's well worth it.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[John W. Vinson]

Hi!
I have a lot of queries that are based on other queries, which are based on
some other queries, etc... Quite a mess!
I would like to simplify SQL of the top queries so that they are based only
on tables, not other queries. It would be too complicated and time-consuming
to do it manually, so I'm wondering if there is some commercial or free tool
that can make it automatically? It would save me lot of time and nerves...
I suppose that Access do something like that internally, right?

Thanks,

Zlatko

Well, BACK UP YOUR DATABASE before you even think about doing such
changes... and then I'd recommend one of these tools. Speed Ferret is
my favorite.

Freeware: http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com

John W. Vinson [MVP]

 

[tatamata]

Thanks for sugestions, but I need some tool that automatically translates
query with subqueries into plain query with tables...
Best regards,

Zlatko

 

[John W. Vinson]

Thanks for sugestions, but I need some tool that automatically translates
query with subqueries into plain query with tables...

Good luck. That sounds like a nightmarishly difficult text-parsing
project.

John W. Vinson [MVP]