# Re: 如何用SQL来过滤某个月的资料(Select..From....

Posted by richard on December 08, 1998 at 09:34:08:

In Reply to: 如何用SQL来过滤某个月的资料(Select..From.... posted by Bird Shen on December 08, 1998 at 07:37:21:

: 如何用SQL来过滤资料
: 用日期来过滤,我试了一下:
: Data1.RecordSource = "Select * from [交易资料] where[日期] >" & #11/27/98#
: 但是这样好像不行耶！！
: 请大家帮帮小弟!!谢谢!!
"select * from [交易日期表格] where [交易日期]
between #" & 交易日期1 & "# and #" & 交易日期2
& "#"

Follow Ups: