Thanks Duane...but are you saying that Tahun dipil should be the header of the main report?, becaue if we compare with your previous sugggestion the year would be the header and the Name of the officers (NamaPel) will be in the detail.

I am a bit confused.

Thanks in advance

Frank



Duane Hookom wrote:

You could probably just use the TahunPel in the detail report and set
19-Nov-09

You could probably just use the TahunPel in the detail report and set its
criteria to the last 5 years.

Then your txt0 - txt4 would have values like:
=Year(Date())
=Year(Date())-1
=Year(Date())-2

The link child properties would need to be the year field.


--
Duane Hookom
Microsoft Access MVP


"Frank Situmorang" wrote:

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
Excel Conditional Hiding Without VBA
http://www.eggheadcafe.com/tutorials...al-hiding.aspx