Subject Re: (no subject) From Agostinho <Agostinhoteixeira@yahoo.com > <Agostinho <Agostinhoteixeira@yahoo.com >> Date Mon, 13 Dec 2021 13:29:27 -0500 Newsgroups dbase.getting-started Dear Mervyn thank you for supporting Note that my field contain only 'j' for paid invoices and ' ' (empty) for non paid invoices Mervyn Bick Wrote: > 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.