Trouble getting a parameter field to work
I'm trying to filter records form the database by requiring that one field is "greater than or equal to" a parameter entered by the user before searching to DB.
The parameter field loads and accepts user input okay, but I'm not getting it to tie into the selection formula for some reason.
Here's my formula:
Code:
{tblCustomers.TotalVisits} >= {?TotalVisits}
When I try to save the formula I get the following error message:
This array must be subscripted. For example: Array[i].
Any ideas?
Re: Trouble getting a parameter field to work
The "Allow Multiple Values" option of the Parameter is ON. Either turn that option off or specify which element of the array to use
{tblCustomers.TotalVisits} >= {?TotalVisits}[2]