penfold1992
Registered User.
- Local time
- Today, 09:17
- Joined
- Nov 22, 2012
- Messages
- 169
I would like to join my two tables in vba together so I can reference them in the same way,
ie.
Set rs = dbs.OpenRecordset(SQLstr)
Me.Summarystr = Nz(rs![Summary], Null)
so I want to be able to combine two tables together in the SQL string in order to have both information inside the same record set...
I just tried this but it didnt seem to like it, anyone got any ideas?
ie.
Set rs = dbs.OpenRecordset(SQLstr)
Me.Summarystr = Nz(rs![Summary], Null)
so I want to be able to combine two tables together in the SQL string in order to have both information inside the same record set...
Code:
SQLstr = "SELECT * FROM [table1] " & _
"FULL OUTER JOIN [table2] ON [table1].[sequence]=[table2].[sequence] " & _
"WHERE [table1].[sequence]='" & _
Me.seq.Value & "'"
I just tried this but it didnt seem to like it, anyone got any ideas?