as am beginner for access and i have loadz of data which is similar to the one which i have posted in (https://www.excelforum.com/excel-gen...her-sheet.html) and data is going to be stored in table(sheet) and output has to be effected in other table(sheet). Due to much data excel is getting slow and taking hours in order to get output. And the produced qty has to be entered manually date wise . I have no idea how to do this in access. Can anyone over here help me out.