Need help with a S Q L statement inside VBA

Are you actually doing this in excel? If so, how?

Originally Posted by Kyle123

Are you actually doing this in excel? If so, how?

Sorry, the system does not allow users to post with some S Q L keywords, so I have to add some extra space.

I did it all the time. I often use VBA to pull data from database. Basically, I put S Q L statement inside CVQuery, such as: CVQuery = " Se le ct * From TableName Where ......."

That is it.

Dim CVConnectionString As String
Dim CVRs As ADODB.Recordset
Dim CVQuery As String
Dim CVField As Field

Let me rephrase the question, are you actually querying a real database? If so which one? Or are you querying another workbook?

Originally Posted by Kyle123

Let me rephrase the question, are you actually querying a real database? If so which one? Or are you querying another workbook?

Real database, I pull data from Sybase, which is used in my workplace. But it should be able to pull other database.

Originally Posted by Poizhan

Try this SQL logic-

Attachment 575184


This will return the person only-

Attachment 575189


This will return all records, with a person meeting the qualifications-

Attachment 575191

Thank you very much!

It is kinda complicated for me to understand.