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



    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