Hi Guys,

I was wondering if you could help please. I'm trying to transfer from a Database Table --> Excel based on an Excel Template.

The data to extract is coming from a query called "qryCodeFix" in which I want to display certain fields based on what is selected on a form, the criteria used is:

Go-Live Date in SMPx Week x

SMP is basically a time period split down into weeks. E.g there would be SMP07 Week 1, 2, 3 & 4.

The qryCodeFix is as follows:

Please Login or Register  to view this content.
As an example SMP07 Week 1 is between 15/09/2014 and 21/09/2014 however the SQL above will not work for the 15/09/2014 for some reason. When I run the query in Access it will however display info from the rest of the timeframe.

I'm trying to display the results in an Excel Template using the following VBA code:

Please Login or Register  to view this content.
However when I select SMP07 Week 1 run the code it will not display any information - it doesn't give any errors when running and saves the excel sheet to the relevant folder.

Which makes me think it's not picking up my query somehow therefore won't display any data? Or I've messed up somewhere on the SMP and Week function....

As you can tell I'm a complete novice (but eager to learn!) and any help would be greatly appreciated.

Many thanks.