[AccessD] Speed up DAO processing

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.



More information about the AccessD mailing list