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 derfloh 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
Joined
Feb 7, 2013
Messages
152
Location
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

mhshane
  • Question Question
Is this the best way to do this query?
Replies
9
Views
595
mhshane
mhshane
combo
  • Locked
  • Question Question
SQL data types in CREATE/ALTER TABLE queries
Replies
2
Views
3K
combo
combo
Swi
  • Locked
  • Question Question
Jet Sql Statement - Select Distinct Multiple Columns
Replies
4
Views
1K
Swi
Swi
accesshelp1
  • Locked
  • Question Question
How can I remove parenthesis and everything that comes after it?
Replies
3
Views
1K
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question Question
Can not get Access 2016 queries to accept form value input or TempVars! input
2
Replies
21
Views
2K
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top