Hi All,
So sorry to be back with the same theme, but somehow I just can't get the hang of these SQL Statements! I hope the kind person who helped last time is still around!
Set Gebuehr = db.OpenRecordset("SELECT * FROM tblxx_Gebuehr " _
& "WHERE tblxx_Gebuehr.tblxx_grabart_id= " & Grabart AND " _
& "tblxx_Gebuehr.tblxx_Gebuehrkategorie_ID= " & Kategorie AND " _
& "tblxx_Gebuehr.deleted=0 AND " _
& "(tblxx_Gebuehr.tblxx_friedhof_id Is Null OR tblxx_Gebuehr.tblxx_friedhof_id = " & Friedhof &"))"
Where Grabart, Friedhof and Kategorie are variables. I think it has something to do with the way I tray and break the lines up but have tried a million different ways!
Thanks a lot
Marion
So sorry to be back with the same theme, but somehow I just can't get the hang of these SQL Statements! I hope the kind person who helped last time is still around!
Set Gebuehr = db.OpenRecordset("SELECT * FROM tblxx_Gebuehr " _
& "WHERE tblxx_Gebuehr.tblxx_grabart_id= " & Grabart AND " _
& "tblxx_Gebuehr.tblxx_Gebuehrkategorie_ID= " & Kategorie AND " _
& "tblxx_Gebuehr.deleted=0 AND " _
& "(tblxx_Gebuehr.tblxx_friedhof_id Is Null OR tblxx_Gebuehr.tblxx_friedhof_id = " & Friedhof &"))"
Where Grabart, Friedhof and Kategorie are variables. I think it has something to do with the way I tray and break the lines up but have tried a million different ways!
Thanks a lot
Marion