Gustav Brock
gustav at cactus.dk
Thu Sep 4 11:02:12 CDT 2003
Hi Lonnie In that case you may be better off with DAO and Seek. /gustav > I'm going to try the query process. I have a question. One of my issues is that Table1 where all the transactions go has many fields that get filled dynamically based on a field in the other tables > like so... > Table1 has fields... > "Client", "2003R", "2003F", "2003P" > Table2 has... > "Client", "PE", "Amount" > Table2 Data > Client PE Amount > ABC 2003Rx 5 > DEF 2003Px 6 > XYZ 2003Fx 4 > My update query should make Table1 look like... > Client 2003R 2003F 2003P > ABC 5 > DEF 6 > XYZ 4 > See I have to dynamically select the field that the AMOUNT is going into by whats in a field in the from table. I don't know how to dynamically determine the field name with an SQL statement. This > is what I tried... > DoCmd.RunSQL "INSERT INTO Table1( Client, Left([PE],4))SELECT Client, Amount FROM Table2" > This is why I was using the recordset method because I could dynamically determine the field name with each iteration.