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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Quick quotation mark question

Status
Not open for further replies.
JasonPurdueEE

JasonPurdueEE

Technical User
May 21, 2002
131
US
can somebody help me out with my quotation marks in this line? strSQL1, strSQL2, and so on are all strings. I want OverallSQLstr to be the string that is formed by the combination of strSQL1 through strSQL5 WITH the "(" brackets in it. How do I get the quotation marks set up correctly on this line?

OverallSQLstr = "(strSQL1(strSQL2(strSQL3(strSQL4(strSQL5)))))"

Thanks in advance.

JASON

 
Sort by date Sort by votes
nevermind, I think I got it.

OverallSQLstr = "(" & strSQL1 & "(" & strSQL2 & "(" & strSQL3 & "(" & strSQL4 & "(" & strSQL5 & ")))))"
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

rdpress
  • Locked
  • Question
Question Open Shellling to File Explorer
Replies
3
Views
349
Andrzejek
Andrzejek
RolandR
  • Locked
  • Question
Access Rich Text Memo Field Question
Replies
1
Views
359
RolandR
RolandR
VickyC
  • Locked
  • Question
Field question in DAO 1
Replies
3
Views
225
Andrzejek
Andrzejek
irethedo
  • Locked
  • Question
Run-time error '3078' question... 2
Replies
12
Views
669
Andrzejek
Andrzejek
ICCIIT
  • Locked
  • Question
MS Access Runtime 2010 quick question..
Replies
3
Views
154
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top