A
Al Smith
I have a query - Contacts - that is used as the basis for a subreport in a
Patient's data report.
The Contacts are imported from Outlook, and linked to the database.
The Contacts, as they are in Outlook, have categories, and sometimes,
multiple categories.
The categories are, e.g., Patient 1, Patient 2, Patient 3, Patient 4.
In the main database, a list of patients, alias' are assigned to each
patient, as Patient 1, Patient 2, Patient 3, Patient 4.
Problem:
Report is for Patient 1:
When linking the subreport to the main report, how can I set criteria for
the Contacts Query to only filter out the Contacts that show Patient 1 ?
I've tried the Like operator, but it will not work. I'm not sure if it's
because the Contacts categories are seperated by a comma (or semi-colon), or
it's just not possible.
Perhaps, when the subreport is opened, I should run a macro that appends to
another "contacts" table to rename a "WhoFor" field, as Patient 1 or Patient
2, etc, and then run the subreport on that table.
Thanks in advance,
Al Smith
Patient's data report.
The Contacts are imported from Outlook, and linked to the database.
The Contacts, as they are in Outlook, have categories, and sometimes,
multiple categories.
The categories are, e.g., Patient 1, Patient 2, Patient 3, Patient 4.
In the main database, a list of patients, alias' are assigned to each
patient, as Patient 1, Patient 2, Patient 3, Patient 4.
Problem:
Report is for Patient 1:
When linking the subreport to the main report, how can I set criteria for
the Contacts Query to only filter out the Contacts that show Patient 1 ?
I've tried the Like operator, but it will not work. I'm not sure if it's
because the Contacts categories are seperated by a comma (or semi-colon), or
it's just not possible.
Perhaps, when the subreport is opened, I should run a macro that appends to
another "contacts" table to rename a "WhoFor" field, as Patient 1 or Patient
2, etc, and then run the subreport on that table.
Thanks in advance,
Al Smith