Duane in my understanding report will take value from query and query will take value from table. So if we do not have a calculated field in query how can we link it.
I also refer to your previous email Nov 13 saying 5 set of subreport.
OK I will try again to make it only one subreport. But if you still have a rather easy one I appreciate. The problem because we have to choose in combo box the year of service, then it will show, for the last 5 years in the report.
Thanks very much,
As I stated, there is only one subreport.
As I stated, there is only one subreport. I am not sure where you got the
Year[X] columns in your main report record source. What's wrong with the main
report record source as I suggested in my reply on 11/18 and the subreport
record source from 11/23?
Previous Posts In This Thread:
EggHeadCafe - Software Developer Portal of Choice
Look Ma, No DataBase! Bamboo Prevalence