Home>

About access reports
Regarding ↑, I have solved it once, but I have a problem again, so I will ask you a question.

Thanks to hatena19, I was able to get the report I wanted.
However, adding the Resignation Master to the record source of the report creates duplicate records.

What this means is that we have added a field called Type to the Resignation Master to specify which resignation to output when printing.
For the type, we have entered three types of resignation: promotion, assignment, and transfer.

And since each sentence is different, the record in the letter field will also change.

If i make a query with this statement master and the record source (transfer history) of the report
Employee number, announcement date, transfer department, resignation master, type
123 March 1, 2012 Sales Section 3 Promotion
123, March 1, 2012, Sales Division 3, Assigned
123, March 1, 2012, Sales Division 3, Transfer
123, March 1, 2018, Sales Division 2, Promotion
123, March 1, 2018, Sales Division 2, Assigned
123, March 1, 2018, Sales Division 2, Transfer
123, March 1, 2020, Sales Section 1, Promotion
123, March 1, 2020, Sales Section 1, Assigned
123, March 1, 2020, Sales Section 1, Transfer

It will be like this.
Hiding the Resignation Master restores it, but once you close the query, the Resignation Master fields themselves disappear.

Probably because of that, it doesn't extract the announcement date and the transfer department well.
"As of March 1, 2020, I will order the work of Sales Division 1 to Sales Division 1."
What I want you to be like above
"As of March 1, 2020, I will order the work of Sales Division 2 to Sales Division 2."
It looks like this ...

Is it possible to improve this?

I was able to specify the type of report and even preview it, so it's one more step ...
I would like you to help me.

Sorry to trouble you, but thank you.