Hi all,
I'm not sure if this is the right forum to post in as my Q may be MSAccess related. I am using an ADO connection to retieve data from an Access database using Excel VBA - this seems to be functioning properly (I am able to get data as required).
My problem is modifying my SQL statement - currently I have;
The above is just a test to see weather or not it worked (and it does). I want to be able to select the data based on week numbers. The current [Date] is in format '24/03/2006' - how do I modify this statement?
TIA, any ideas appreciated......and again someone here may know (bob??)
Bookmarks