InStr Parameter in Report Title

[Huddle]

I have two fields in my SQL query Quarter and MyParameter: InStr([Enter Quarter separated by commas: 1,2,3,4],[Quarter])



For MyParameter let's say for example I enter 1,2,3

I want the report title to read Summary Report for Quarter(s) 1,2,3

I tired ="Summary Report for Quarter(s) " & [Quarter] in the report but it only returns Summary Report for Quarter(s) 1

How can I get the parameter entry to show in the report title?

[June7]

InStr returns the position of the found string, not the string. So if [Quarter] = 2 then the position in 1,2,3 = 3, not 2. Why do you need Instr?

="Summary Report for Quarter(s) " & [Enter Quarter separated by commas]

However, parameter prompts are annoying, I don't use them. Have user enter value in textbox on form and refer to textbox:

="Summary Report for Quarter(s) " & Forms!formname!textboxname

[Huddle]

I need the parameter for the query. I tried using the Forms!formname!textboxname in the Quarter field in the query but it doesn't work with the commas. How can I do a list box in the form where they can click on multiple quarters and have it work with the query and the report title?

[June7]

What do you mean 'doesn't work with the commas'? User types in the desired string: '1,2,3' or '2,3,4' or '3,4,1' or whatever. The commas are just text.

How does this pertain to query? You want the input to be criteria for filtering records? As well as use in the report title?

Using a multi-select listbox will be complicated. Review: http://allenbrowne.com/ser-50.html

[Huddle]

Decided to go a different way. Thank you