soupisgood84
Technical User
I am looking for some guidance. I wrote a SQL statement that returns only one result every time for a table. I need to get the data from that result into a string so I can modify it before I put it into another table. What should my next step be or should I use a recordset?
CODE:
<code>
selectSQL = "SELECT Table1.F1" & " "
fromSQL = "FROM Table1" & " "
whereSQL = "WHERE (((Table1.F1) Like 'Free space *'))"
SQLstatement = selectSQL & fromSQL & whereSQL & ";"
CurrentDb.QueryDefs("qryImport(tmpTable1)").SQL = SQLstatement
</code>
CODE:
<code>
selectSQL = "SELECT Table1.F1" & " "
fromSQL = "FROM Table1" & " "
whereSQL = "WHERE (((Table1.F1) Like 'Free space *'))"
SQLstatement = selectSQL & fromSQL & whereSQL & ";"
CurrentDb.QueryDefs("qryImport(tmpTable1)").SQL = SQLstatement
</code>