How to capture data from Report, save to table

[Bobby1st]

Cannot you move the calcs into a query?

. This is the best solution however, it won't work for there's a lot of variables. You mentioned append, I thought of saving the report data on the same table (tblMonth) and append to tblYTD, this won't work because the table is key (no dups). I tried this also, while the multiple reports is running on the query tblMonth, I created a code to run: Set rst = dbs.OpenRecordset (tblYTD) etc. It save what's on the screen, it saved the correct EmpId, date, and supervisorId but rest of the data is the previous employee. I can't understand that. I have explained rst.MoveNext is not applicable when result is running on a query.

Unless you or someone can help, I have to place the code (save) on the button for Individual, meaning run the individual, input the empId then save result and repeat, I know this work. While the other button generate all employee report is only for printing. I will be asked why do they have to do it one at a time?

Thank you.

 

[namliam]

I am pretty sure any calculations you do on the report can be done in a query or multiple queries.

For Access to create a report, the base values must be captured someplace in the DB, from that same DB you can just as well create queries as reports.

 

[Bobby1st]

Cannot you move the calcs into a query?

. This is the best solution however, it won't work for there's a lot of variables. You mentioned append, I thought of saving the report data on the same table (tblMonth) and append to tblYTD, this won't work because the table is key (no dups). I tried this also, while the multiple reports is running on the query tblMonth, I created a code to run: Set rst = dbs.OpenRecordset (tblYTD) etc. It save what's on the screen, it saved the correct EmpId, date, and supervisorId but rest of the data is the previous employee. I can't understand that. I have explained rst.MoveNext is not applicable when result is running on a query.

Unless you or someone can help, I have to place the code (save) on the button for Individual, meaning run the individual, input the empId then save result and repeat, I know this works. While the other button generate all employee report is only for printing. I can see unfavorable feedback why have to do it one report at a time?

Thank you.