Basically, I am creating a Crystal Report to view beginning/ending balances of the general ledger. I am trying to make a parameter prompt so that the user can choose the types of accounts that they would like to see. I only need 2 values: 'ALL' (for all of the accounts) and '10001-10007' (for only those accounts.

Now, my problem is when I create the prompt I am not sure what to use as the value? I created a prompt with the values 'ALL' and 'is between 10001 and 10007'. But, when I use the selection expert, it only gives me the limited options ('is any value', 'is between...', etc.). So, if I use the value in the selection expert, then I would need something that can either choose all of the values for the particular field OR be able to choose only a particular set of records ('is between 10001 and 10007'). No matter which option I choose for the selection expert, it will not pick up all or a particular set of records.

I was thinking that maybe I could use VB code in the parameter prompt, but there is no place to input it (or call the custom function).

Thank you for any help,
grmrpr