Quotes and SQL

[cranebill]

I have the following SQL statement:

Me!Config.RowSource = &quot;Select Distinct HConfig From Hoist Where TIncl <> -1 And HType = &quot;&quot;&quot; & Me!HoistType & &quot;&quot;&quot;&quot;

This works however I need to add more criteria that are text strings and for the life of me these quotation marks are going to drive me bonkers.

This is what I have:

Me!Capacity.RowSource = &quot;Select Distinct Cap From Hoist Where TIncl <> -1 And HType = &quot;&quot;&quot; & Me!HoistType & &quot;&quot;&quot; And HConfig = &quot;&quot;&quot; & Me!Config & &quot;&quot;&quot;&quot;

This doesnt work... what are the rules on this for i have more than just this one to add...

Bill

 

[DaltonVB]

Try using the 'tick' instead of double quotes.

Me!Capacity.RowSource = "Select Distinct Cap " _
                      & "  From Hoist " _
                      & &quot; Where TIncl <> -1 &quot; _
                      & &quot;   And HType = '&quot; & Me!HoistType & &quot;' &quot; _
                      & &quot;   And HConfig = '&quot; & Me!Config & &quot;'&quot;