error with the syntax of the sql statement

[kavya]

My actual sql statement is following.

sqlstr3 = "select file_num, filing_date from filing inner join company on
filing.cik = company.cik where company.cik = '" & rs1.Fields("cik&quot & "'"
And filing.doc_type_code = "BD"

Let me explain what I am doing.
I want to select the filing number, filing date from filing table where
filing.cik = company.cik and where form.filing says 'BD'

Thanks in advance

 

[Sawatzky]

dear kavya,

try this

select file_num, filing_date from filing inner join company on
filing.cik = company.cik where company.cik = '" & rs1.Fields("cik&quot & "'
And filing.doc_type_code = "BD"

I deleted a " behind : & rs1.Fields("cik&quot & "'