I am trying to run a date difference query in my Access database. I am new to Access so I am not even sure what the query would be and how exactly I would run it.
I have two fields named Date of Discovery and Date Processed and I need to find the date difference between the two; or how many days are in-between the two. However, I also need it to be only business days so it does not include weekends when counting, is there anyway to do that? I would like this number difference to appear in my field named # of Days.
What exactly would my query be and where would I save this or how do I run it? The name of my Table is EF&L Table.