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

Posted by CATE on December 08, 1998 at 07:50:52:

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#
: 但是这样好像不行耶！！
: 请大家帮帮小弟!!谢谢!!

Data1.RecordSource = "Select * from [交易资料] where [日期] > #11/27/98#"

Follow Ups: