3 Replies Latest reply: Jan 24, 2013 8:25 AM by barhopper147 RSS

    Duplicate Invoices within tolerance

      Hi everyone,


      I have a small issue that's really beginning to bug me.


      I have a database with say the following columns:


      - InvoiceValue
      - InvoiceDate

      - InvoiceNumber


      What I am trying to do is create a straight table that looks for duplicate invoices where the invoice number is the same (easy) but also the invoice value is within 0.01p (tolerance). I can't seem to get the expression correct for the 0.01p part.


      I think this is most probably really simple, but I just can't get it right.



      Many thanks in advance