Modify the criteria of the query to include the records

OR

Add the bill codes with the correct date range on the student records.