getting more of working query..
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=22757
Printed Date: 29 March 2026 at 5:17am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: getting more of working query..
Posted By: deepak
Subject: getting more of working query..
Date Posted: 22 February 2007 at 7:24am
|
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: michael
Date Posted: 22 February 2007 at 2:28pm
|
just do a where d_dob between .... AND d_sex ='Male' ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: deepak
Date Posted: 24 February 2007 at 6:40am
thanks.. 
|