Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jan 2006
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Extra ) (Access 2000)

    I want to open a report according to the month chosen in the option box

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Extra ) (Access 2000)

    The problem is in the WHERE part of the SQL string. To find out where, keep track of the number of opening and closing parentheses. You'll find that there are more closing parentheses than opening parentheses. Try to balance them. Also, insert a space before the word And.

    Note: there are several superfluous opening and closing parentheses in the WHERE part.

Posting Permissions

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