Query of a Query possible?

[knauftj]

I have a query called A that includes a field called DuesAmount. This field is pulled from a second query I'll call B. Query B includes a field called DuesDate that needs to be filtered by a field in Query A called LastDuesDate. I've tried several things to accomplish this but I keep running into circular reference errors (for obvious reasons). Any ideas to pass the LastDuesDate field to Query B? Thanks.

Jon

 

[xenou]

If A depends on B which depends on A you may have a truly impossible situation. Can you construct a third independent query with the LastDuesDate criteria needed by A, so B can call A without A calling B?

 

[knauftj]

Alexander,

You gave me an idea. I think I might be able to do away with Query B which is causing all the issues. I'm going to use a DLookup to pull the amounts I need that were being calculated by Query B. I may lose some performance but the end result will be easier to maintain moving forward. Thanks.

Jon