Get data for only last three months
 

HI Tom

What it now does with the modification is instead of giving me July t
September it gives me January to March.

What am I doing wrong

--
popp
-----------------------------------------------------------------------
poppy's Profile: http://www.excelforum.com/member.php...fo&userid=1145
View this thread: http://www.excelforum.com/showthread.php?threadid=26604

Get data for only last three months
 

I suspect it gives you July to September, but places the information unde
January to March.

If that is the case, then you need to do adjust the j to reflect the start
month

however, if that were the case, then going back to using m should solve the
problem - but you said it was off by several columns.

So there are several things I don't know

How you implemented the suggested change
(for example in the query string, did you replace m with j -- if so, you
shouldn't have)
What happens in Call PopulatePage(j)
And based on what information you have determined that it gives you January
to March.

--
Regards,
Tom Ogilvy


"poppy" wrote in message
...

HI Tom

What it now does with the modification is instead of giving me July to
September it gives me January to March.

What am I doing wrong?


--
poppy
------------------------------------------------------------------------
poppy's Profile:
http://www.excelforum.com/member.php...o&userid=11453
View this thread: http://www.excelforum.com/showthread...hreadid=266048