Subject Re: (no subject) From Mervyn Bick <invalid@invalid.invalid> Date Mon, 13 Dec 2021 09:07:18 +0200 Newsgroups dbase.getting-started On 2021/12/13 06:37, AGOSTINHO wrote: > Dear group > This is my debtors file I want to filter all the non paid records, all the paid invoices > are marked with "j" and the non paid invoices are not marked just left '  ' (empty) > Now I need  to get all the non paid invoices filtered > I've tried to do the following  but there is no way I can get the file filtered. > How do I solve this issue? > .......... > >     with (this.DEBITEUR1.rowset) >        filter = "betj_n = ' '" >     endwith > > Thanks > Agostinho > Try this instead to display the unpaid records.     with (this.DEBITEUR1.rowset)        filter = "betj_n <> 'j' and betj_n <> 'J'"     endwith To display paid records     with (this.DEBITEUR1.rowset)        filter = "betj_n = 'j' or betj_n = 'J'"     endwith Mervyn.