I love PRogramming

How to use Between Statement that can identify the month/date/year . thank you

For MS SQL an example is

SELECT * FROM Orders
 WHERE OrderDate BETWEEN '1996-07-01' AND '1996-07-23'

For AccessDB use

SELECT * FROM Orders
 WHERE OrderDate BETWEEN #1996-07-01# AND #1996-07-23#
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.