Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    England
    Posts
    1

    Post Unanswered: Parameter Select Query - Need Help Please

    I am wanting to use a Parameter query to select a number of records.

    The records I want to include have different account types e.g. 84 and 85

    So in my field I have put the parameter name in the criteria and in the parameter i am typing the following text:

    84 or 85

    But this does not work!!

    They are both the same data types so that is not a problem but no records are being pulled through and I know that there should be some.

    In Access is there a way of using logic operators in a parameter that is being used as criteria??

    If so please help me asap

    Regards,

    Stewart Hayles

  2. #2
    Join Date
    Dec 2003
    Location
    WA, USA
    Posts
    51

    Re: Parameter Select Query - Need Help Please

    try using IN(84,85)
    Bob

Posting Permissions

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