Hi Everyone, I've seen some questions about this issue and perhaps I'm thinking to difficult to answer my own problem.
What is my issue?
Every month I have to make a report about registration of hours of a group of employees. (These employees have a deal with direction about travel hours vs. working hours).
This report has to be send to the group members but only the data which is valid for the group member in it. There are 11 persons in this group so I have to send 11 reports.
I've tried several solutions found on this forum and on the Internet but none are what works for me. First of all: I made a query with the hours registered from this group. I couldn't export it because it was read-only. That was because the query contains joins to the employee table.
After that I tried it with a report. That nearly went well but it contained all data and not the seperated info.
What I need to know:
After that I need to do a mail-merge.
But first of all do I need to make the seperated reports to work.
Suggestions are welcome.
Kind regards, AKS69CW
What is my issue?
Every month I have to make a report about registration of hours of a group of employees. (These employees have a deal with direction about travel hours vs. working hours).
This report has to be send to the group members but only the data which is valid for the group member in it. There are 11 persons in this group so I have to send 11 reports.
I've tried several solutions found on this forum and on the Internet but none are what works for me. First of all: I made a query with the hours registered from this group. I couldn't export it because it was read-only. That was because the query contains joins to the employee table.
After that I tried it with a report. That nearly went well but it contained all data and not the seperated info.
What I need to know:
- What is easier/better: use a query or use a report?
- Is there code which looks in my query or the report and makes it into seperated reports?
After that I need to do a mail-merge.
But first of all do I need to make the seperated reports to work.
Suggestions are welcome.
Kind regards, AKS69CW
Last edited: