关于数据库查询!(解决问题有分送!)
我做的一个数据库查询,想对上一个查询结果继续查询,该如何做?
我用的方法是:
sSQL = "select name,tel1,tel2,tel3,email,oicq from info where name like '*" & mFindInfo & "*'or tel1 like '*" & mFindInfo & "*' or tel2 like '*" & mFindInfo & "*' or tel3 like '*" & mFindInfo & "*' or email like '*" & mFindInfo & "*' or oicq like '*" & mFindInfo & "*' or letter like '*" & mFindInfo & "*' or py like '*" & mFindInfo & "*' or introduction like '*" & mFindInfo & "*' ORDER BY py "
Data.RecordSource = sSQL
Data.Refresh
查询结果出来了,我想继续查(在这个结果里),该怎么办?请不要将我的思路完全,呵呵,那就太麻烦了!
谢谢!