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.
TIA,
Simon
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.
TIA,
Simon