A
aspgk
Here's the scoop
1. I had a query with all built and working great
2. it processes against a table with some joins
3. I wanted the exact same query to run against another table
4. I copied the query, brought in the new table, pointed the data elements
to the new table, join the table to the other stuff, then deleted the
original table it replaced.
5. When running the new query, many qualifying records did not output
6. Creating the same query from scratch produced the right results.
7. I thought i'd same development time doing this and ended up spending
several hours trying to debug it....
Please advise & thanks
Paul
1. I had a query with all built and working great
2. it processes against a table with some joins
3. I wanted the exact same query to run against another table
4. I copied the query, brought in the new table, pointed the data elements
to the new table, join the table to the other stuff, then deleted the
original table it replaced.
5. When running the new query, many qualifying records did not output
6. Creating the same query from scratch produced the right results.
7. I thought i'd same development time doing this and ended up spending
several hours trying to debug it....
Please advise & thanks
Paul