Error in SQL from Query Design Grid?

[Guest]

Hi there
Have you ever experienced a problem with the SQL generated from the Query
Design Grid?

I've been generating some complex queries (which have a number of
sub-queries 'feeding' the main query) and in the process I've had to amend
them fairly radically. When the data that was returned wasn't what I
expected I tried numerous solutions to find out what I'd done wrong but
didn't get anywhere. In the end I generated a NEW query (via the QDG) which
was identical in content and structure to the erroneous one and now it works
fine!!
I haven't had the time to pick through the SQL to see what the problem was
as it's lengthy and complex but I just wondered if this was a known issue and
if so, are there certain circumstances where this is more likely to occur.

Thanks guys!

Lee

 

[djbiehl via AccessMonster.com]

The only thing that I can think of is if you explicitly defined things in the
sub-queries that the parent queries depended on, and during the course of
amending the sub-queries, the parents couldn't find what it defined to find
in the sub-queries. Couldn't tell you much more without getting specifics
from you...

 

[Guest]

Thanks, that's a good point which I hadn't considered! I expect you're right
so basically I need to be a little more careful when using and changing
sub-queries.

Much appreciated.

Lee