Compound loop statement

's Computer Specifications

I cannot figure why the following code drops out early

Do While Cells(1, iArrayCol).Value <> iCurrYr _
And Cells(2, iArrayCol).Value <> iCurrMth

iArrayCol = iArrayCol + 1
Loop

iCurrYr = 2006
iCurrMth = 10

But, the loop terminates when it gets to the values 2005 & 10.

The correct values are in the data.

I'm at a loss.
--
Graham

's Computer Specifications

Graham,
Change And to Or
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"Graham" <(E-Mail Removed)>
wrote in message
I cannot figure why the following code drops out early

Do While Cells(1, iArrayCol).Value <> iCurrYr _
And Cells(2, iArrayCol).Value <> iCurrMth

iArrayCol = iArrayCol + 1
Loop

iCurrYr = 2006
iCurrMth = 10

But, the loop terminates when it gets to the values 2005 & 10.
The correct values are in the data.
I'm at a loss.
--
Graham

's Computer Specifications

Thanks Jim

That fixed it.

I have a history of problems with logical and & logical or. Despite being
conscious of it and giving these things extra thought, I still get it wrong.
--
Graham

"Jim Cone" wrote:

> Graham,
> Change And to Or
> --
> Jim Cone
> San Francisco, USA
> http://www.realezsites.com/bus/primitivesoftware
>
>
> "Graham" <(E-Mail Removed)>
> wrote in message
> I cannot figure why the following code drops out early
>
> Do While Cells(1, iArrayCol).Value <> iCurrYr _
> And Cells(2, iArrayCol).Value <> iCurrMth
>
> iArrayCol = iArrayCol + 1
> Loop
>
> iCurrYr = 2006
> iCurrMth = 10
>
> But, the loop terminates when it gets to the values 2005 & 10.
> The correct values are in the data.
> I'm at a loss.
> --
> Graham
>

's Computer Specifications

You are not alone; had a few mix-ups myself.
Jim Cone

"Graham" <(E-Mail Removed)>
wrote in message
Thanks Jim
That fixed it.
I have a history of problems with logical and & logical or. Despite being
conscious of it and giving these things extra thought, I still get it wrong.
--
Graham

"Jim Cone" wrote:
> Graham,
> Change And to Or
> --
> Jim Cone
> San Francisco, USA
> http://www.realezsites.com/bus/primitivesoftware
>
>
> "Graham" <(E-Mail Removed)>
> wrote in message
> I cannot figure why the following code drops out early
>
> Do While Cells(1, iArrayCol).Value <> iCurrYr _
> And Cells(2, iArrayCol).Value <> iCurrMth
>
> iArrayCol = iArrayCol + 1
> Loop
>
> iCurrYr = 2006
> iCurrMth = 10
>
> But, the loop terminates when it gets to the values 2005 & 10.
> The correct values are in the data.
> I'm at a loss.
> --
> Graham
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Compound IIF Statement	DAC	Microsoft Access Queries	2	26th Jun 2009 07:28 PM
Compound IF statement	=?Utf-8?B?RGk=?=	Microsoft Excel Programming	8	18th Sep 2007 05:12 PM
Compound IF Statement?	=?Utf-8?B?QnJvb2s=?=	Microsoft Access Queries	7	10th Mar 2006 06:09 PM
Compound Statement	=?Utf-8?B?YmxhZGVsb2Nr?=	Microsoft Access Reports	1	26th Sep 2005 05:08 PM
Compound loop conditions	Bill	Microsoft Access Form Coding	2	14th Apr 2005 05:27 PM