Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Mar 2006
    Posts
    195
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Not in a crosstab query (Access 2000)

    In my crostab query i am trying to use additonal criteria to exclude some customers.I use the <> criteria but it doesnt work in the crosstab.Shall i use another query ? I am sending the query tooo
    Attached Files Attached Files

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Not in a crosstab query (Access 2000)

    Your query is working for me. Can you explain what's not working for you ?
    Francois

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

    Re: Not in a crosstab query (Access 2000)

    The query works for me too.
    For example, if I select the first office in the form, the query lists customers 1 and 4 without the criteria, and only customer 4 with the criteria.
    So the condition <>1 works correctly.
    What exactly is your problem?

  4. #4
    2 Star Lounger
    Join Date
    Mar 2006
    Posts
    195
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Not in a crosstab query (Access 2000)

    Thank you ! It works My Fault !

Posting Permissions

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