Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
rammohan
Posting Yak Master
212 Posts |
Posted - 2006-11-13 : 04:16:25
|
my table:Studentid date status101 11/08/2006 A101 11/09/2006 A101 11/10/2006 P101 11/11/2006 Pmy query: select status from mytable where studentid = '101' and date between '11/08/2006' and '11/11/2006'i want to return this 2p's and 2A's to another function by this query, but its giving status at 11/08/2006, staus at 11/11/2006.i am using MsAccess.can u show me a solution?thanx in advance,rammohanOne can never consent to creep,when one feels an impulse to soarRAMMOHAN |
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-13 : 04:30:57
|
Try this:select status from mytablewhere studentid = '101' and date between #11/08/2006# and #11/11/2006# Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
rammohan
Posting Yak Master
212 Posts |
Posted - 2006-11-13 : 05:17:27
|
Thanks you it is working now...One can never consent to creep,when one feels an impulse to soarRAMMOHAN |
 |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-11-13 : 06:55:31
|
In Access when passing dates you should use # in place of 'MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|