report as excle report (1 Viewer)

[mohamedmatter]

Hi Group, thank you for providing assistance and solving most of the problems that many members encounter. I have a problem in preparing a report for a group of employees and printing it. I have attached a picture of the format of the report that was prepared on the Excel program. I ask for help in preparing this report on the Access program. I have also attached a simplified version of the database. An explanation of the problem is to work out the total salaries at the end of each page for the group of employees on this page, and on the next page at the top of the row that contains the total of the previous page, and so on until the end of the report.

 

[arnelgp]

maybe you can use temporary table to ouput your report.
see the code behind the report.
and open the report in "print preview".

 

[mohamedmatter]

maybe you can use temporary table to ouput your report.
see the code behind the report.
and open the report in "print preview".

Thank you very much. Great work. I would like to understand the idea of the work

 

[Gasman]

maybe you can use temporary table to ouput your report.
see the code behind the report.
and open the report in "print preview".

@arnelgp
If you have 18 entries on the first page all at 1000 each, how does that total become 19000?
On the next page you get 37000 for the next 18 entries? which is correct for that page, and the next one at 55000 ?

 

[mohamedmatter]

@arnelgp
If you have 19 entries on the first page all at 1000 each, how does that total become 19000?
On the next page you get 37000 for the next 18 entries? which is correct for that page, and the next one at 55000 ?

Yes, there is a big error in the totals. Is there a solution?

 

[mohamedmatter]

@arnelgp
If you have 19 entries on the first page all at 1000 each, how does that total become 19000?
On the next page you get 37000 for the next 18 entries? which is correct for that page, and the next one at 55000 ?

@arnelgp
If you have 19 entries on the first page all at 1000 each, how does that total become 19000?
On the next page you get 37000 for the next 18 entries? which is correct for that page, and the next one at 55000 ?

I thank Professor Gasman for this note

 

[Gasman]

Sorry, I meant 18 on the page.
The final total is correct though?
I have amended my post accordingly.

 

[arnelgp]

If you have 18 entries on the first page all at 1000 each, how does that total become 19000?

i corrected it (hopefully) on this new upload

 

[Gasman]

Hi @arnelgp that now totals correctly, but appears now not to as the last number is 66, but the total is for the 60 entries.
There are gaps between 19 & 23 and 42 & 46.

I expect if they were just names it would not be noticable, so I would cetrainly not show the code_id.

Nice work all the same

 

[arnelgp]

There are gaps between 19 & 23 and 42 & 46.

thanks for noticing.
but that is the original data i got when i downloaded the db on post #1.
you can also check that on the employee_tbl, there is already a gap on them.

 

[Gasman]

thanks for noticing.
but that is the original data i got when i downloaded the db on post #1.
you can also check that on the employee_tbl, there is already a gap on them.

Ah, I see, my apologies.

 

[mohamedmatter]

i corrected it (hopefully) on this new upload

Thank you, Professor Arnelgp, for your wonderful effort. Although I was late in thanking you for your efforts. I would have liked a simple explanation of the idea of this work so that I could train myself on similar ideas. You have my thanks and appreciation.

 

[mohamedmatter]

Ah, I see, my apologies.

There is no need to apologize, enough for your wonderful diamond