Recordsets & Insert into
Posted on 1997-10-21
I need some advice. I am using a recordset to select each row in a query and then performing many date comparison calculations on the date columns in the record. The final calc I end up with is a total # of days for the row. I then compare this value to another value which determines whether this record should appear on my report. What is the best way to capture this value for the record? I had created an empty column in my underlying table that the query is based on and then updated this value with the vtotaldays (total #of days). Then I used the query as the recordsource for my report. This seems inefficient to me. I also tried to use a DoCmd.RunSQL "Insert into..." command to insert the records I want into another table. However, I am having trouble inserting the variables from my calculations into the new table. Any suggestions and/or advice is welcome. Thanks.