DATE CALCULATION from SELECT query

Eyo1 asked:

Dear Professionals,

I am lost in this problem below:

I have an Access Table that stores Members Info including date of births.
With my Windows Forms Application using VB2010, I want to query the Members Table to select only members whose birth dates fall between NOW and the next 7 days.

That is, Peter's Birth date is: 27rd Sept. 1982. But today's date is 24th Sept. 2012.
In 3 days time, Peter will be celebrating his birth date.

With this in mind, I have created a listbox control to store the names of persons selected from the members' table whose birth date is between NOW and next 7 days.

I only need to retrieve the SELECT statement and I can populate the LIST Box control with the data using a ADODB.RECORDSET object.

I do not know how to complete the SELECT query of this task. Please can someone help me?

NB:
MS Access
Windows Forms
Visual Basic 2010.

Tags: Visual Basic

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

Cancel

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

Please note that all posts will be submitted under the http://www.codeproject.com/info/cpol10.aspx.