Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can this SQL work 1

Status
Not open for further replies.
fileman1

fileman1

Technical User
Feb 7, 2013
152
GB
I am trying to find if 2 items are already in a recordset.

rs3.FindFirst "ID1 =" & PK1 & "KeywordID =" & PK2

It errors saying something missing in syntax.
 
Sort by date Sort by votes
lets assume that ID1 = 1, and PK1 = 2

rs3.FindFirst "ID1 =" & PK1 & "KeywordID =" & PK2
would resolve to
ID1 =1KeywordID =2

rs3.FindFirst "ID1 = " & PK1 & " AND KeywordID = " & PK2
This would resolve to
ID1 = 1 AND KeywordID = 2
 
Upvote 0 Downvote
Many thanks for the help, and clear explanation.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
2K
combo
combo
Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
908
Swi
Swi
accesshelp1
  • Locked
  • Question
How can I remove parenthesis and everything that comes after it? 1
Replies
3
Views
855
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Can not get Access 2016 queries to accept form value input or TempVars! input 2
2
Replies
21
Views
1K
TheresAlwaysAWay
TheresAlwaysAWay
TheresAlwaysAWay
  • Locked
  • Question
Create query that will divide work among employees 1
Replies
7
Views
441
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top