cdb424ttm
asked on
Report and sub report
I’m using Access 2003; I have a report in my database which has a sub report on it.
I use this for keeping track of family drugs. Who is taking what and so forth. I the main report I have a listing of all the drugs for that family member. At the top of the report is where the sub report is. This report only shows the names of the doctors for that member only. My question is how to hide the sub report for all the members of the family except for dad. So when I print the report for my dad it show doctors name but when I print it for others I don’t want the sub report to show. Can this be done?
Thanks for any help.
I use this for keeping track of family drugs. Who is taking what and so forth. I the main report I have a listing of all the drugs for that family member. At the top of the report is where the sub report is. This report only shows the names of the doctors for that member only. My question is how to hide the sub report for all the members of the family except for dad. So when I print the report for my dad it show doctors name but when I print it for others I don’t want the sub report to show. Can this be done?
Thanks for any help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
using access 2003 NBrownoh
ASKER
no answer on this pelase give not points and close question out.
Thanks
CDB
Thanks
CDB
The answer to your question is Yes it can be done.
If you would like to respond to the comments I'm sure someone can give you the help you apparently need.
Bob