View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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