String for query

mardi 17 mars 2015

I have a query which working fine:


Code:



strSQL = "Select [nazwa], [id_wycena_pre], [Format_(X)], [Format_(Y)], [kolory p], [kolory t], [nazwa_id], [iloscstron], [numerarkusza], [naklad_pracy], [Kolory P], [Kolory T] from tblGoraZleceniaNowaWyceny where [id_wycena_pre]=" & Forms!frmWycenyObszarRoboczy!ID_wycena_pre & " and [nazwa]='" & "środek" & "' or [nazwa]='" & "okładka" & "'"

Set rst = CurrentDb.OpenRecordset(strSQL)...



But now I would like to add next condition to this query


Code:



where [kolory p] is not null or [kolory t] is not null


- these fields are string

I don't know how to wrtie this condition and add to my exiting strSQL string:/

String for query

0 commentaires:

Enregistrer un commentaire

Labels