Results 1 to 4 of 4

Thread: parameter query

  1. #1
    New Lounger
    Join Date
    Feb 2001
    Location
    Ohio
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    parameter query

    I have seen examples between such and such dates. What do I put in place of between for one number? say 42. Do I just put =["type the operation number you are looking for"] .
    Is there a list of the operators anywhere?

    John

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: parameter query

    Dear John,

    If I understand correctly, you don't want fancy parameters like between #date1# and #date2# you just want to enter a single parameter like 42. In that case you are correct, just use the wording you suggested.

  3. #3
    New Lounger
    Join Date
    Feb 2001
    Location
    Ohio
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: parameter query

    Thank You
    I will try it in the morning. I wasn't sure if I just used the equals sign then the brackets or something else.

    Thanks
    John

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: parameter query

    To see all the operators, lookup the word Operators in the Help index.
    You do not need the = in your expression. Just type the phrase you want to display in the parameter window within square brackets.

    [Type the operation number]

    Place it in the criteria cell for the field on which you are performing the search.

Posting Permissions

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