I am trying to create a database for our productivity. I want to know if Access can enter data based on the number of duplicate dates entered. At most, only 2 of us are working at a time(for now). So, when there are 2 duplicate dates I want the query to label each person as a count of 0.5, otherwise when there is 1 person working, I want it to enter 1 into the field for the count. Is that possible? Just as an FYI, I am self taught when using Access, I do not have any formal training. But I have also created a database that keeps up with the procedures we do on a daily basis, so I do have some knowledge. Thank you in advance for any assistance you are able to provide!