J
Jack
I have been struggling with this problem for a few days now....and I don't
know how to start writing this code. I would like to create a form which
creates the first filter for the report which is by date. Then when the user
selects the command button a report "rptdistribution" is distributed by email
to employees listed in "Table1", here is the tricky part.....each user should
only get only their respective departments report and for the date selected
above. The fields that I have in Table1 is UserName, DeptName, Emailaddr.
Table2 has the Date field "activedate". I really hope that someone has
overrcome this problem in the past or knows how to help me solve this coding
challange. Thanks in advance! J
know how to start writing this code. I would like to create a form which
creates the first filter for the report which is by date. Then when the user
selects the command button a report "rptdistribution" is distributed by email
to employees listed in "Table1", here is the tricky part.....each user should
only get only their respective departments report and for the date selected
above. The fields that I have in Table1 is UserName, DeptName, Emailaddr.
Table2 has the Date field "activedate". I really hope that someone has
overrcome this problem in the past or knows how to help me solve this coding
challange. Thanks in advance! J