myquery s.Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

i have an sql that starts like thi

sSelect = "s.*

how can i define that only spesific records are to be chosen?

Erik
 
Hi,

i have an sql that starts like this

sSelect = "s.*"

how can i define that only spesific records are to be chosen?

Erik
Click to expand...

By adding a WHERE clause:

"select s.* FROM tablename AS S WHERE s.ThisField = 3 and s.ThatField
= 'Desired Text' and s.Datefield = #3/1/2004#"

You may want to create the query in the Query Design grid selecting
the desired fields and records (the s.* syntax is not always a good
idea, specific fields will be more efficient) and view the SQL of the
query as a model for building your string.
 
Back
Top