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