Find script showing records that dont match too.
I have 2 tables - Invoice and InvoiceDetails. Invoice details stores each product, cost of each item. Invoice stores the InvoiceTotal a calculation field ( based on sum(item cost) from invoicedetails.
I am trying to create a report where I want to fin all invoices where InvoiceTotal is >200. I am using a basic find script. However when I run this I get many records some of where the total is >200, some equal to 200 and sometimes less than 200 too. The find criteria strictly states to find only those records where Total is >200.
What am I doing wrong?