i want to pull all orders from the database that is less than the Date the Order Entry entered.

DateSubmit -- is the date in the database as a Date field
Date -- is the date enter by the Order entry

rs.Open "Select * from tblTestOrder, tblCustomers where CustomerID = CustID AND DateSubmit = '" &Date& "'", conn

right now, it pulls all order with or without "DateSubmit= '"&Date& "'".
When i take out the quotation around DATE; i got an 0x80040E10 error.

please help

What's the database? if it is Access it may need "#" delimiters around the date

date in ASP will return the current system date so the query in your example will be getting records where the entry date is equal to the current date

somewhere in there you need to be using a JOIN statement as the way the query is set is very inefficient

do you need all fields from both tables?

thanks.