VBA SQL Select (Code included)

[Jasper XAFAX]

Hi all,

I have this bit of SQL that I can't get working.

rst1.Open "SELECT Studenten.* FROM Studenten WHERE (((Studenten.Printen) Is Null) AND ((Studenten.VerzendenNaar) Is S));"

I know the first part is proper untill ....((Studenten.VerzendenNaar) Is S));" is proper but I can't seem to get the end right. If the field VerzendenNaar in the table Studenten has an S in it I wan't it to select it.
Pretty please with suggar on top tell me what I am doning wrong. (Probably simple as pie)

Thank you all and have a nice easter!

Jasper

[hspc]

rst1.Open "SELECT Studenten.* FROM Studenten WHERE (((Studenten.Printen) Is Null) AND ((Studenten.VerzendenNaar) ='S'));"

use is when comparing to null
use = with numbers , strings

[Jasper XAFAX]

First of all let me thank you for your time and effort.
Thank you very much for explaining. Maybe you can telle me something else I have A question about.
My piece of code is reffering to a table, is it possible to make a selection from a query? I can't seem to get it right.

Best regards,

Jasper

[hspc]

My piece of code is reffering to a table, is it possible to make a selection from a query? I can't seem to get it right.

yes you can save a query in access and select from it (query it)
also in SQL Server you can save a query as a view and select from it.

if you are using access open a new query .. write your select statement (or use the query builder) then save it..
in your code you can say :

Select * from Query1 where ......... etc.

[TheCPUWizard]

Or.... use nested Select statements [SQL Server and other "real" DBMS for this, Access has problems with it!]

[hspc]

Originally posted by TheCPUWizard
Or.... use nested Select statements [SQL Server and other "real" DBMS for this, Access has problems with it!]

yes . nested queries are options..but using views can increase performance and decrease the complexity of the query.

I also used sub queries in access..not bad till now

[Jasper XAFAX]

Hello hspc and THECPUWizard,

Thank you again for your time and effort to answer my question, I had weekend and a day of because of easter so that is why I didn't express my gratitude till now.
I am on my way again, thank you for your time and effort.

Best regards,

Jasper

[hspc]

Hello hspc and THECPUWizard,
Thank you again for your time and effort to answer my question, I had weekend and a day of because of easter so that is why I didn't express my gratitude till now.
I am on my way again, thank you for your time and effort.

Best regards,

Jasper

you are always welcome