AnsweredAssumed Answered

Find script showing records that dont match too.

Question asked by Dees on May 28, 2013
Latest reply on May 28, 2013 by philmodjunk

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

      

Outcomes