We have a gate access control system that we can retrieve usage data in Excel format. Unfortunately, some of the records are at the same station and within a short period of time. I would like to have a way to remove these unwanted records either in Access or in Excel and then import to Access. Within same username any record within ten seconds of the previous date and time would be removed. With the new recordset then have two reports created that recaps usage for a selected time. One report to show total record count by User and then a second report to show all usage within a date range and a breakpoint on username with totals.
44 freelancers are bidding on average $134 for this job
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
Dear SIr, I'm expert in boss access and excel and ready to help you in removing unwanted records and can share you sample of my work, msg me for details Kind Regards, NourElDeen