Thanks dilip!!!

It's working now.

It makes sense after looking at your Select statement.  But I'm still need to do some studying on GROUP BY.

Thank you again.

That was exactly my problem. Thanks! Bellis. 

And you're right about using the correct datatype.  Thanks! Remi.

Thanks Farrell!!

It works Beautifully!! THANK YOU!

Also thanks Remi for your assistance.

Hi Remi,

I tried your Select statement and it's giving me

Invalid column name ‘work_ord_num’.  Would you know where the error is occurring?  Or some other way...

Hi Remi,

Thanks for your quick response.

I got it partially working w/ this Select statement. It's able group by the six digits and return the highest bag #, but it also...

Yes! It works now.

Thank you for your time and patience.

Have a great day!

I also tried outputting to @w_o variable still get the same error message. The error occurred during executing sproc in vb on line below

  .Execute , , adExecuteNoRecords

the @w_o is...

Hi,

when I run the sproc below.

Am I missing CAST or CONVERT function in the code?

Hi Remi,

Thanks for the code.

Now the error saids it can't convert  '123456-00' to int data type. I don't need it to be int. It needs to be char.  Why am...

Hi Remi,

I said adding one to string field. What I really want is subtract one from the field to get previous work order.

This field stores work order& release #(123456-00) in the...

Hi Remi,

THanks for the quick reply.

I'm trying to increment the last digit by 1: 123456-01

How and what is the best way to accomplish this?

Thanks!

Thanks Ron for your reply.

I did left out BEGIN/END by mistake but I also thought if the @opt variable is 1  the second select statement will execute.  Thanks for your explanations.

Thanks Remi!

Hello Remi,

Thanks for the code and explanations.

I have two questions

If the @@rowcount variable gets resetted to 0 shouldn't the return value be 0?what puzzles me is that it keeps on...

Thanks Remi!