Work Around

  • Thread starter Thread starter Mark A. Sam
  • Start date Start date
M

Mark A. Sam

From reading other posts of the same problem from time immemorial, I decided
that there was no explaination and resolved this with the following work
around. If you encounter this issue, maybe my work around will help you:

The problem query, named _ProductsRemaining was fed by two select queries
named, _SumProducts and _SumProductsShipped.

I renamed them _SumProductsMakeTable and _SumProductsShippedMakeTable, and
turned them into maketable queries which created local tables, _SumProducts,
and SumProductsShipped. I run the maketable queries before I open the
report.

Now _ProductsRemaining are fed by the new local tables rather than queries.

God Bless,

Mark A. Sam
 
This was meant to be a reply to my post of 1/23/06 with the subject, Invalid
Operation
 
Back
Top