Syntax for multiple WHERE in recordset?

Hi Folks

Heres what I have (and this work fine BTW):

rst_con_calc.Open "SELECT tbl_conversion.conv_to FROM tbl_conversion WHERE
tbl_conversion.conv_from=" & "'" & cmb_content_from & "'" & "", cnn,
adOpenDynamic, adLockReadOnly

I need another two criteria in the WHERE clause but this syntax is pretty
dark stuff! What I need is something like:

WHERE tbl_conversion.conv_from=" & "'" & cmb_content_from & "'" & AND "_
"tbl_conversion.conv_to=" & "'" & cmb_content_to & "'" & AND "_
"tbl_conversion.conv_typeconvert=" & "'"cmb_typ_conv &"'" & "", cnn,
adOpenDynamic, adLockReadOnly

Does that make any sense at all? Help appreciated.

--
Cheers

------------------------
Kahuna
------------------------


.

Relevant Pages

  • Re: Not Exists joining 2 tables
    ... "'code' is a bad name for a key column" is a valid complaint. ... EXISTS clause with a correlated subquery properly, ... SQL+ syntax and start using the ANSI SQL syntax that seems ... Then the only criteria in the where clause ...
    (comp.databases.ms-sqlserver)
  • Syntax for multiple WHERE in recordset? - Sorry Folks Originally Posted in Wrong Group (Controls
    ... I need another two criteria in the WHERE clause but this syntax is pretty ... dark stuff! ...
    (microsoft.public.vb.database.ado)
  • Re: CROSS JOIN
    ... > was that depreciating the original FROM .. ... WHERE syntax would never ... > The problem is that the WHERE clause is done after the FROM clause. ... but thats just outer join stuff. ...
    (comp.databases)
  • Re: Extending define with where clause
    ... > parallel to lambda*, which implements automatic handling of keyword ... "where" clause is used that the new syntax really matters. ... introduced with the help of let, letrec, letrec*, or named let -- are ...
    (comp.lang.scheme)
  • Re: update query: still having problems
    ... Only the records from Department that have a rate value present in sheet1, ... That is how an INNER JOIN works when there is no duplicated values (in one ... you add an extra WHERE clause. ... Your code throws up a syntax error: ...
    (microsoft.public.access.queries)
Quantcast