Hii, I am generating a report for Machine batch data in Access. In that all the data is being recorded in Access Database for every second. For Reporting I want to filter that data as per set time interval means as per 30 sec. or 60 sec. How can I Filter that data as per my set Time interval. After filtering it should show the record of each 30 second or 60 second. It is just to compress the length of report.
Thanks and waiting for reply.....