Urgently need some help!

I have some missing items in my inventory. Here is situation.

One Location. One Product (All scanned in by MAC address) I have atleast 5 missing as of my count this morning.

3 people use one user to scan out items. Not ideal I know. But I would like to find out how to generate a report of all the items that where checked out between X & Y dates. So I can see the times they where taken. I have cameras I can go find the person if they are indeed stolen after that.

I need to solve this before the weekend so we don't keep loosing money.