Print Page | Close Window

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.. Smile



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net