Help for building a query string with double quotation mark, thanks a lot!

X

xpengi

Joined
Jul 5, 2005
Messages
22
Reaction score
0
hi,

i have a query which include some double quotation marks as below, (Tb is table's variable name)

SELECT Switch(IsNull(Amount),"NULL",Amount<=10000,"0 to 10000",Amount<=20000,"10001 to 20000",Amount>20000,"20001 and up") AS Range, Count(SISID) AS NumStudents
FROM Tb
GROUP BY Switch(IsNull(Amount),"NULL",Amount<=10000,"0 to 10000",Amount<=20000,"10001 to 20000",Amount>20000,"20001 and up");


i want to build it as query sting in code,
for example,
...
dim strSQL as string

strSQL = "Select ...????..from " & Tb & "Group...????..."
...

how to deal with "" marks which is already in query?

Really thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to count some data percent based on table? Thanks a lot!! 0
A query to return the range of a sum of values 3
Help for building a statistical query, thanks a lot! 0
Help for MS Chart Control 6.0, thanks a lot! 0
Building WHERE string; Passing Combo Box Value to a Query 1
Display the result of a query in a text box on a form 2
Query for Double Quotes / Quotation Marks 3
More help need with my double col lookup function 10

Top