thanks Vikas

you are a life saver, the latter query was what i wanted and it's works perfectly

thanks, it's the update which shouldn't happen if the condition if false. if the update doesn't happen the procedure won't be executed anyways.

hi Vikas

thanks for the modification of the code... it's works.

just one other thing it this condition "IF @liMaxMaxID < @liNextID - 1" is false how do i rollback the transaction??

the reason is that the table "UDMLastTransaction" has only one record if this criteria " IF @liMaxMaxID < @liNextID - 1" is met, i'm setting the MaxTransactionID to "SET @liMaxMaxID...

THANKS GUYS, I'M GONNA IMPLEMENT THE CODE AND SEE IF IT'S WORKS

MUCH APPRECIATED

i don't understand

the end of the code looks like:

END

CLOSE lMCursor

DEALLOCATE lMCursor

END

hi Gail

thanks for responding so soon

the error is coming from this line "FETCH NEXT FROM lMCursor INTO @liMaxMaxID" and here "WHILE 0 = 0"

thanks for the response,

i don't know what i'm doing wrong here but here's the scenario

DECLARE

...

thanks guys for responding.... i just had a look at it and i think it's what's i'm looking for

thanks, will try that

hi dschubel

thanks for responding and i think this might help, just one thing though

i assume this line Application.FollowHyperlink Me.Filepath

is where i define the file path and in my case is...

thanks again, the answer to your last question is

i want to display on the subreport

thanks for the response

yes i did put it in the ColumnHeadings but the thing is i don't want to display the whole 12 months on the report, only those month...

hi

i need to do something similar to this but a bit different, in my case i have specific weeks that i need to get the dates of.

for week 36,37,38,39 i...

in my table i have a date column, the data starts from 2004 - 2008 i'm required to count all records captured from 2004 to 2008 and divide it with...