gold007eye
Registered User.
- Local time
- Today, 18:18
- Joined
- May 11, 2005
- Messages
- 260
HOLY Explicit!!!
Ok.. I FINALLY got it figured out and didn't even need INNER JOIN.
Here is the code that worked
And on a side tid-bit I tried for kicks and giggles.. (Removed the space after the WHERE (" and code still works
Thanks for all of your help.
Ok.. I FINALLY got it figured out and didn't even need INNER JOIN.
Here is the code that worked
Code:
strSQL = "Select * INTO " & TableName & " FROM [Letter Information] WHERE ([Letter Information].ID)=" & Forms![Search Form]![SID] & ";"
And on a side tid-bit I tried for kicks and giggles.. (Removed the space after the WHERE (" and code still works
Code:
Select * INTO zzpzdc FROM [Letter Information] WHERE ([Letter Information].ID)=123351;
Select * INTO zzpzdc FROM [Letter Information] WHERE ([Letter Information].ID)=139961;
Select * INTO zzpzdc FROM [Letter Information] WHERE([Letter Information].ID)=111382;
Thanks for all of your help.