Hey remember I told you I'm not the only that works on this database. I had no clue what that code does. I commented it out and plan to remove it later. Now it works but it still doesn't capture the end date.
for example if I want to search for records from 11/01 to 11/04, it would only give me up to 11/03. is there a "<=" (less than or equal) function I can use so those missing records can also display?