I am having trouble generating pdf file based on a criteria set in a query. Currently the file name is as listed below;
Plan 92 Provider #1 07.08.2011
Plan 92 = is part of the that on the report (this is what I need to add based on that field in the table)
Provider #1 = Reference
07.08.2011 = DraftDate
I need to add the PlanType at the end of the file name based on the criteria set in the query. This is where I am having trouble, the PlanType is in the “tluFundsImport” table. I tried setting the criteria in the “qryRPT1” query to generated just those PlanType 92, but it is creating pdf for all files, and disregarding the query.
I need to create a separate report for each Reference Number, and having a pdf file for each Reference, but only if there is a record: an example of what I need is as follows:
Reference, PlanType, DraftDate, it should look like this: Provider #1 Plan 92 07.16.2011
I will be creating a different report for each Plan Type, and will need to generate just the records with these Plan Type for each Reference.
I file is attached. Thanks in advance!