Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - how 2 Query
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

how 2 Query
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
deepak View Drop Down
Newbie
Newbie
Avatar

Joined: 19 February 2007
Location: India
Status: Offline
Points: 8 		Post Options Post Options   Thanks (0) Thanks(0)   Quote deepak Quote  Post ReplyReply Direct Link To This Post Topic: how 2 Query
    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.
Back to Top
MrMellie View Drop Down
Senior Member
Senior Member
Avatar

Joined: 12 December 2006
Location: United Kingdom
Status: Offline
Points: 251 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MrMellie Quote  Post ReplyReply Direct Link To This Post Posted: 22 February 2007 at 9:09am

Confused

So d_sex='Male' for all male records...?
Back to Top
deepak View Drop Down
Newbie
Newbie
Avatar

Joined: 19 February 2007
Location: India
Status: Offline
Points: 8 		Post Options Post Options   Thanks (0) Thanks(0)   Quote deepak Quote  Post ReplyReply Direct Link To This Post 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 &"#;"
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post 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.
Blog | MPG Tracker
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.