VB and seq

[Gregsy35]

i am tryin to run a query thru vb
the query will find all dates in a database between 2 dates selected on a control. When i tried this thou i select dates in which i no date exists for in the database but it comes up 0 every time

can anyone please please help!??
cheers gregs

 

[oneshadow]

1. What kind of database you're using? (MS Access, SQL Server, Oracle...)
2. How's your query syntax?

 

[albanian]

Keep in mind that each query with dates, regardless of the date format you have in your computer needs to have the format mm/dd/yyyy. So it is always a good idea to use the function format(dt,"mm/dd/yyyy&quot for the dates.

 

[chiph]

I've used format(dt, "yyyymmdd&quot when inserting records. That way the field is naturally sorted. You still need to use a "Order By" clause on your SQL, but there's much less work involved for the database server.

Chip H.