I have three queries that all of the same parameter name (“Curr Ac Yr”).
But there are two prompts - one for 2 queries and 1 for the 3rd.
I thought if the parameters were the same name, only 1 prompt would display (and then fill each query)?
The 1st prompt has query logic of “greater than or equal to” for the “In Brigade” query, and the “Active or Lv Abs” has query logic of “less than”.
The 2nd prompt has query logic of “equal to”. (I changed to to “Less than” and it still came up as the 2nd prompt)
There are no spaces at the end …