I work for non-profit agency and I have created a db and made it collect the data I want but I want it to track it for the month and I can only figure out how to do it for the last occasion rather than all of them.I need it to track all instances of all the items that are tick boxes and I need to associate all dates with the referral items. It is a small db, so I will attach it and feel free to add/edit the table. I am sure this can be done with VB, but I am not that advanced.