There are two parts to the issue. First part is getting ALL into the LOV query. Second part is properly handling the event when a user selects ALL in response to the prompt. The code you have does not handle ALL properly in the resulting SQL.
Dave Rathbun (BOB member since 2002-06-06)