1 Reply Latest reply on May 28, 2013 9:11 AM by philmodjunk

    Find script showing records that dont match too.

    Dees

      Title

      Find script showing records that dont match too.

      Post

           Hello,

           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?

            

           Thanks

           Dee

            

                      
                     Preferences
      §
      1
      2
      3
      4
      5
      6
      7
      8
      9
      0
      -
      =
      Backspace
                           
      Tab
      q
      w
      e
      r
      t
      y
      u
      i
      o
      p
      [
      ]
                                
      Return
                                
                           
      capslock
      a
      s
      d
      f
      g
      h
      j
      k
      l
      ;
      '
      \
                           
      shift
      `
      z
      x
      c
      v
      b
      n
      m
      ,
      .
      /
      shift
                           
                                
                               English
                                     
                                     
      alt
      alt
                           
                      
                     Preferences

            

        • 1. Re: Find script showing records that dont match too.
          philmodjunk

               Can you post that "basic find script"?

               How is the invoice total computed? (there's more than one way)

               To post a script to the forum:

                 
          1.           You can upload a screen shot of your script by using the Upload an Image controls located just below Post A Answer.
          2.      
          3.           You can print a script to a PDF, open the PDF and then select and copy the script as text from the opened PDF to your clipboard for pasting here.
          4.      
          5.           If You have FileMaker Advanced, you can generate a database design report and copy the script as text from there.
          6.      
          7.           If you paste a text form of the script, you can use the Script Pretty box in the Known Bugs List database to paste a version that is single spaced and indented for a more professional and easier to read format.