job_expiration_date can be null...this code is giving me a DBNULL error...anyone know the proper way i can do this or do I have to write two separate sql statements?

VB Code:
  1. If objDR("job_set_up_date") <= tranPeriod And (objDR("job_expiration_date") >= tranPeriod Or (objDR("job_expiration_date") Is DBNull.Value)) Then