Results 1 to 2 of 2

Thread: Trouble getting a parameter field to work

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    May 2008
    Location
    Bunker Hill, WV
    Posts
    154

    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?

  2. #2
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    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]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width