I have a DB where i have a list of clients and links (via a hyperlink field) to various documents they have sent us.
What i am trying to do i run some filters to filter the documents and then run a report that lists the various clients and the pdfs (usually letters) they have sent us.
Query and filters work fine but I have hit a brick wall when it comes to running a report that shows the pdfs.
Is this at all possible? I have been searching the web for a couple of days and can't find a way to do it. Most responses regard to displaying a pdf in a sub-form on a form, but I need the option to filter and include them in a report.
Note for my queries and filters I could end up with 50-100 pdfs so having to manually filter and group them isn't my preferred route.
Are you trying to, effectively, have the contents of the various PDFs appended one after the other in some type of display that can also print? Or do you simply want a header list that can open each PDF when clicked upon? Also does this need to be something you can send to others?