Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transpose data Months & Data to Rows Deeds Excel Discussion (Misc queries) 18 January 8th 07 04:28 PM
I want to put 1 years data and 1 months data togheter on one char. Philippa Charts and Charting in Excel 1 February 21st 05 01:10 PM
Last Months Data!! Jeff Excel Worksheet Functions 4 December 20th 04 09:05 PM
Get data for only last three months poppy Excel Programming 1 October 4th 04 02:38 PM
Get data for only last three months poppy Excel Programming 2 October 4th 04 01:41 PM


All times are GMT +1. The time now is 11:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"