VB & Database, Need help with Select statement syntax to retrieve Access2000 record between two dates

Need help with Select statement syntax to retrieve Access2000 record between two dates

Author	Message
Samuel Phun #1 / 5	Need help with Select statement syntax to retrieve Access2000 record between two dates Hi all, I'm using ADO 2.6, VB6 and Access2000. I needed to retrieve record from the Access2000 table between two dates. Can anyone help me with the proper Select statement syntax. I use the following statement and not able to get it to work. "SELECT * FROM tbl_Invoice WHERE InvDate BETWEEN '" & dt_date1 & '" AND '" & dt_date2 & "'" Thanks in advance!
Sun, 31 Jul 2005 08:03:43 GMT

#2 / 5	Need help with Select statement syntax to retrieve Access2000 record between two dates
Fri, 19 Jun 1992 00:00:00 GMT

Sukesh Hooga #3 / 5	Need help with Select statement syntax to retrieve Access2000 record between two dates Quote: > Hi all, > I'm using ADO 2.6, VB6 and Access2000. > I needed to retrieve record from the Access2000 table between two dates. > Can anyone help me with the proper Select statement syntax. > I use the following statement and not able to get it to work. > "SELECT * FROM tbl_Invoice WHERE InvDate BETWEEN '" & dt_date1 & '" AND > '" & dt_date2 & "'" > Thanks in advance! --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003
Sun, 31 Jul 2005 10:05:07 GMT

#4 / 5	Need help with Select statement syntax to retrieve Access2000 record between two dates
Fri, 19 Jun 1992 00:00:00 GMT

Paul Clemen #5 / 5	Need help with Select statement syntax to retrieve Access2000 record between two dates Hi all, I'm using ADO 2.6, VB6 and Access2000. I needed to retrieve record from the Access2000 table between two dates. Can anyone help me with the proper Select statement syntax. I use the following statement and not able to get it to work. "SELECT * FROM tbl_Invoice WHERE InvDate BETWEEN '" & dt_date1 & '" AND '" & dt_date2 & "'" Enclose the date values with pound sign (#) characters instead of single quotes in order to identify them as date values. Microsoft MVP (Visual Basic)
Sun, 31 Jul 2005 21:44:27 GMT

Page 1 of 1

[ 5 post ]