Recent content by beatrice1981

Thank you all for looking into this. I'll check your suggestions first thing in the morning. @ The_Doc_Man - how would you explain no bloat for "select * from SomeTab"? I just don't get it :( ps. "select field1, field2, sum(coalesce(field5, 0)-coalesce(field6)) FROM SomeTab group by 1,2,3,4"...

Thank you all for your time. @ jdraw - hope you don't mind, but to an 8-year-old it would go like this :) Let's say I have a list of 50 POKEMON NAMES in access table. There's an external datasource with all pokemon data. My task is to create and populate another Access table that contains...

It's a pass-through query. I need some data from ODBC database server for every record in my recordset. I'm altering querydef in every iteration because i use current record values to change criteria in WHERE clause and then insert the single query result into Access table. The question is - why...

Hi, Please help :( I'm working on a code to loop through the dao.recordset and use single record values as a criteria to set querydef.SQL property then run saved PT query, insert PT query result into a table and MoveNext. Code actually works but I can't make my peace with huge db bloat. I've...