Recordset with "and" and "or"

[MarionD]

I think this should be easy but......

I Need to select a recordset based on multiple conditions - basically

Set kids = db.OpenRecordset("Select * from qry_BeitragBerechnen where tblxx_familie_id=" & Familie!ID & " and " & "[Invbegindate]<=" & RundateEnd)

This works fine but now I need to add

" and " & "[InvEnd ] <=" & RundateEnd & " or " & isNULL ([InvEnd])

Basically
Family_Id =x
and
InvBeginDate <= x
andInvEndDate <= x or Null

Hope this makes sense to someone
Thanks
Marion

 

[pbaldy]

Add them, but include parentheses around the 2 in the OR test.

 

[MarionD]

Thank you!
Works now

 

[pbaldy]

Happy to help!