I have a subdata sheet on my master table. I am trying to generate a report that shows the one individual with alll information in the subdata sheet, is this possible, if so what is the best way to accomplish this task
Thanks for all your help
I have a subdata sheet on my master table. I am trying to generate a report that shows the one individual with alll information in the subdata sheet, is this possible, if so what is the best way to accomplish this task
Thanks for all your help
Build a report that has the 'subdatasheet' table (or a query that joins tables) as RecordSource and apply filter criteria. Access Help has guidelines on building reports.
If you want the filter to be dynamic, need to use input popup parameter (I never do that) in query or reference parameter input on form. Review: http://datapigtechnologies.com/flash...mtoreport.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.