Quote Originally Posted by VBDT
Also I don't understand why you are looping through the table rows

I think the order should be only one row!
This is an Pizza Business program and I am searching for records that are on a certain date. Lets say the boss wants to see all the orders for 06/03/2006, it will get every order that has that date, then put its order number, the total price for that order, and eventually I want to be able to add up each total price for each individual order to get a sum total ofthem all. I think I wil do that in the SQL code by usingthe SUM() aggregate function.

If, at a later time, I could easily switch this to allow someone to enter an order number and return just that one record