I have a form with a multi-select list box that I use to filter several reports. If nothing is selected and the button for a report is clicked, all of the data is given, otherwise, if one or more people's names are selected only the data related to the selected individuals is shown.
So far I have 2 reports set up which are working great using this form. I went to add another report, but haven't had the same results. This report is based on a query 'PubMed Info' and has a concatenated text box field on it. When I select a person from the list the report's openargs and filter is set correctly, but the concatenated field does not get filtered. The formula for this field is ="{Insert Reviewer Last Name First Initial[AU] } AND (2003 [DP] OR 2004 [DP] OR 2005 [DP] OR 2006 [DP] OR 2007[DP]) AND (" & ConcatenateOr("Select[Last Name] & ' ' & [First Initial] & '[AU]' from [PubMed Info]") & ")"
I think the concatenation is still pulling from the original query - not the filtered version. Is there a way to have this report & it's field function like the other reports which use this multi-select list?
ps. I haven't found a successful way to incorporate the field into the baseline query itself as it becomes too complex.
Thanks for any responses.
So far I have 2 reports set up which are working great using this form. I went to add another report, but haven't had the same results. This report is based on a query 'PubMed Info' and has a concatenated text box field on it. When I select a person from the list the report's openargs and filter is set correctly, but the concatenated field does not get filtered. The formula for this field is ="{Insert Reviewer Last Name First Initial[AU] } AND (2003 [DP] OR 2004 [DP] OR 2005 [DP] OR 2006 [DP] OR 2007[DP]) AND (" & ConcatenateOr("Select[Last Name] & ' ' & [First Initial] & '[AU]' from [PubMed Info]") & ")"
I think the concatenation is still pulling from the original query - not the filtered version. Is there a way to have this report & it's field function like the other reports which use this multi-select list?
ps. I haven't found a successful way to incorporate the field into the baseline query itself as it becomes too complex.
Thanks for any responses.