bluenoser337
Programmer
I need to query via ADO based on a single date coming from a calendar value control. This works... [Totals.Open "Select sum(a), count(*) from myTable where proddate like '10/2/2002%'", CN] BUT I need the date to come from a variable such as monthview.value from the calendar. How can I replace the '10/2/2002%' with this variable? VB6, SQLServer7. Thanks!