Date Range

[BSG75]

I have an Access database and i am creating a VB program to pull the information into a form in the VB application, i want to be able to pull information based on a date range. I want to have a start date and end date. How do i create the form in vb to pull just the information between those dates i specify? I don't have a query in the database,should i?

 

[johnwm]

Look up the 'Between' keyword in JetSQL help, installed by default at:
"C:\Program Files\Common Files\Microsoft Shared\OFFICE11\1033\JETSQL40.CHM"

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[toon10]

Here's a random example of one of my SQL statements which may guide you.

SELECT DISTINCT * FROM tblSales
WHERE (`Invoice Date` BETWEEN
(# 02 / 13 / 2006 #) AND (# 03 / 15 / 2006 #))
ORDER BY `Val` DESC