Hello, here is somthing I am stuck on.
I get a syntax error, operator is missing
SELECT qrySubOpmerkingenMijlpalen.MO_Opmerking, qrySubOpmerkingenMijlpalen.MO_Inkoopnummer, tblBedrijfsonderdeelhlp.Afkorting, tblInkoopprocessen.* FROM (tblInkoopprocessen LEFT JOIN qrySubOpmerkingenMijlpalen ON tblInkoopprocessen.Inkoopactiviteitnr = qrySubOpmerkingenMijlpalen.MO_Inkoopnummer) LEFT JOIN tblBedrijfsonderdeelhlp ON tblInkoopprocessen.Bedrijfsonderdeel = tblBedrijfsonderdeelhlp.Bedrijfsonderdeel where vervallen_onhold <> 2 and vervallen_onhold <> 1 and tblInkoopprocessen.status <> 'Gereed' AND Inkoper.value ='' AND ((tblInkoopprocessen.Status)<> 'Nog te plannen') AND IIF(DCount('contractnummer','tblKoppelContracten', 'inkoopnummer = '2018(O)000199') > 0,'J','') ORDER BY tblInkoopprocessen.Inkoopactiviteitnr DESC
This part gives the error:
The inkoopnummer='2018(O)000199' is created by the sql part below
" AND IIF(DCount('contractnummer','tblKoppelContracten', 'inkoopnummer = '" & [Inkoopactiviteitnr] & "') > 0,'J','') "
Can anyone help me. It must be somthing simple but I cant find it.
I get a syntax error, operator is missing
SELECT qrySubOpmerkingenMijlpalen.MO_Opmerking, qrySubOpmerkingenMijlpalen.MO_Inkoopnummer, tblBedrijfsonderdeelhlp.Afkorting, tblInkoopprocessen.* FROM (tblInkoopprocessen LEFT JOIN qrySubOpmerkingenMijlpalen ON tblInkoopprocessen.Inkoopactiviteitnr = qrySubOpmerkingenMijlpalen.MO_Inkoopnummer) LEFT JOIN tblBedrijfsonderdeelhlp ON tblInkoopprocessen.Bedrijfsonderdeel = tblBedrijfsonderdeelhlp.Bedrijfsonderdeel where vervallen_onhold <> 2 and vervallen_onhold <> 1 and tblInkoopprocessen.status <> 'Gereed' AND Inkoper.value ='' AND ((tblInkoopprocessen.Status)<> 'Nog te plannen') AND IIF(DCount('contractnummer','tblKoppelContracten', 'inkoopnummer = '2018(O)000199') > 0,'J','') ORDER BY tblInkoopprocessen.Inkoopactiviteitnr DESC
This part gives the error:
The inkoopnummer='2018(O)000199' is created by the sql part below
" AND IIF(DCount('contractnummer','tblKoppelContracten', 'inkoopnummer = '" & [Inkoopactiviteitnr] & "') > 0,'J','') "
Can anyone help me. It must be somthing simple but I cant find it.