border20
Registered User.
- Local time
- Today, 14:31
- Joined
- Jan 8, 2003
- Messages
- 92
I want to do populate a certain field of a blank table with part of another table (for exportation)
What i thought about goes something like this but i doesn'work,,, dont know if it even possible !
Dim SQLstr As String
SQLstr = "Select [number 1] from tablename where [critere 1] = 'c1';"
DoCmd.RunSQL "UPDATE buffer SET [numero 1] = SQLstr;"
I dont know if i can put a SQL statement inside another like this... if this can be done ? what is the correct syntax? if not, how could i achieve my goal ?
What i thought about goes something like this but i doesn'work,,, dont know if it even possible !
Dim SQLstr As String
SQLstr = "Select [number 1] from tablename where [critere 1] = 'c1';"
DoCmd.RunSQL "UPDATE buffer SET [numero 1] = SQLstr;"
I dont know if i can put a SQL statement inside another like this... if this can be done ? what is the correct syntax? if not, how could i achieve my goal ?