[ExcelVBA] Need help in queries when connecting MS access thru vba

 

Hi

 

I am connecting to the MS access from macro, the query I written is,

 

ssql = "select * from Table1 where where Active_Date < " & Date & " and Actual_TDATE > " & Date

 

In the Table1, I've two date fields as Active_Date(from date) & Actual_TDATE(to date), I want to pull only the active rows where the system date should fall between from and to date.

 

Tried with the above query, but not fetching any data. Please tell some alternate queries.

 

Regards,

Satheesh Kumar S

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___