locked
how do i get my table filter to work? RRS feed

  • Question

  •  

    Some tables i have in a report. A couple of them work, but 2 others dont.  I would do it in the query, but then i wouldnt be able to group them in a list.

     

    So my question is, how come i can filter out my BillcustomerCode, but when i want to filter out my subbrand_id (which is an int) or subbran_ Descrition(which is a varchar). how would i filter out these types in the table filter.

     

    Also, how would i do an  "Or" instead of an "and" in my filter too.

     

    I have one table where i need to have 3 things not in the table:

    Bill_Cus_code !=RNPROF

    Bill_Cus_code !=RNPROC

    Sub_Brand_Id ! =65 (or Sub_Brand_Discription != "Pro Club")

     

    how do i do this in the expression. It seems to take out "RNPROF and RNPROC" but not the third one. Why is this?

     

     

    Wednesday, March 26, 2008 2:49 PM

Answers

  •  

    I think i figured it out myself. I went into my table and copied the Pro club and pasted it into the filter, and it finally worked.

    i guess there are spaces in the field.

    Wednesday, March 26, 2008 3:03 PM