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!

SQL Problem 1

Status
Not open for further replies.
fileman1

fileman1

Technical User
Feb 7, 2013
152
GB
Hi Guys, I am trying to replace a fixed number with a variable value

qSql = qSql & " WHERE (((MotorPart.ID1)=495));"

Variable holding value of 495 is MPID

Cheers



 
Sort by date Sort by votes
qSql = qSql & " WHERE MotorPart.ID1=" & MPID

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
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
serino
  • Locked
  • Question
Help with SQL inner join statement 1
Replies
2
Views
474
serino
serino
Wolfdzn
  • Locked
  • Question
Join two seperate SQL into one
Replies
6
Views
598
dhookom
dhookom
dw134
  • Locked
  • Question
Working with SQL
Replies
2
Views
214
BrooksR
BrooksR

Part and Inventory Search

Sponsor

Back
Top