how 2 Query
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=22756
Printed Date: 28 March 2026 at 11:07pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: how 2 Query
Posted By: deepak
Subject: how 2 Query
Date Posted: 22 February 2007 at 7:22am
|
i am able to extract
all those records where d_dob falls under two given date ranges....
following is my working Query:
strSQL = "SELECT matri.* FROM matri WHERE matri.d_dob between # "& dobto &" # and #" & dobfrom &"#;"
Now i Need.... to extract
[all 'Male' records where d_dob falls under two given date ranges..].
d_dob is date field in MSAccess Database
d_sex is txt field in MsAccess Database.
|
Replies:
Posted By: MrMellie
Date Posted: 22 February 2007 at 9:09am
|
So d_sex='Male' for all male records...? |
Posted By: deepak
Date Posted: 22 February 2007 at 12:57pm
|
ya, how 2 code it?
where to insert d_sex='Male' into the following query...
strSQL = "SELECT matri.* FROM matri WHERE matri.d_dob between # "& dobto &" # and #" & dobfrom &"#;" |
Posted By: michael
Date Posted: 22 February 2007 at 2:29pm
|
Answered your other post as I had not see this one first. Please do not double post the same message into different forums. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |