I fixed the decimal problem but here is my output for June 1 to June 30.
Total Sales = $285.34 for the period 1 June, 2007 to 30 June, 2007
Total number of orders = 16
Order Name Payment Purchased Status Referer Campaign Total
51 Sam T Visa / MasterCard (Secure) 28 June, 2007 Shipped $511.85
50 Joe F Visa / MasterCard (Secure) 26 June, 2007 Shipped $204.63
49 Bob K Payment on Local Pickup. We acce 25 June, 2007 Shipped $204.62
48 Tom B Payment on Local Pickup. We acce 25 June, 2007 Shipped $193.80
47 John S Payment on Local Pickup. We acce 25 June, 2007 Shipped $193.23
46 Rick S Payment on Local Pickup. We acce 25 June, 2007 Shipped $62.58
45 Bill B Payment on Local Pickup. We acce 25 June, 2007 Shipped $190.27
44 Chad S Payment on Local Pickup. We acce 25 June, 2007 Shipped $193.80
43 Barry S Payment on Local Pickup. We acce 25 June, 2007 Shipped $204.60
42 Jen R Payment on Local Pickup. We acce 25 June, 2007 Shipped $204.63
40 John B Visa / MasterCard (Secure) 25 June, 2007 Shipped $62.37
39 Andy M Visa / MasterCard (Secure) 24 June, 2007 Shipped $0.00
38 Norm D Visa / MasterCard (Secure) 22 June, 2007 Shipped $204.63
37 Steve E Visa / MasterCard (Secure) 20 June, 2007 Shipped $64.08
36 Paul O Visa / MasterCard (Secure) 19 June, 2007 Shipped $68.75
31 Terry S Visa / MasterCard (Secure) 1 June, 2007 Shipped $25.63
You see that the total up top does not match the sales totals.
Anthony