Search results
-
K
Increment start number values by group wise row depending on Quantity Of Leaves in Access
I have made a little changes on CJ_London provided code. SELECT tblCustomer.ID, tblCustomer.Name, tblCustomer.startno, tblCustomer.endno, tblCustomer.Noofleaves, Format([n]) AS Serial, [Name] & " " & Val([startno])+Val([Serial]) AS Datus FROM t, tblCustomer WHERE ((([t.n])<=[noofleaves]-1))... -
K
Increment start number values by group wise row depending on Quantity Of Leaves in Access
Not all of my row will start from 9432... I am getting data sometimes 1004 rows in a table with different 7 digit number. In my attachment startno and end no difference is the value of qty. -
K
Increment start number values by group wise row depending on Quantity Of Leaves in Access
Dear CJ please don't take it personally. I was working on your post. Your incremented value does not create from 'startno'. its just added a number which is not my requirement. Mr. arnelgp provide me the exact I wanted but my table is getting heavier. -
K
Increment start number values by group wise row depending on Quantity Of Leaves in Access
My sequence is 9432100, 9432101.. from 'start no' and count till quantity of 'noofleaves'. Total 7 digit is count. If my 'start no' is 9432105 then out put will be 9432105, 9432106, 9432107... depending on quantity of 'noofleaves'. Sometime alfanumeric value may come like CC9432105 then output... -
K
Increment start number values by group wise row depending on Quantity Of Leaves in Access
my 'start no' will increment depending on noofleaves like 9432100, 9432101,..94321004, then next row. If my 'start no' start with A then output will be like A9432100, A9432101,..A94321004. then next row. Thank you -
K
Increment start number values by group wise row depending on Quantity Of Leaves in Access
Hello. My table doesn't execute any value if n value does not have 7 digit number. Because "start no" have 7 digit number. if I put 9999999 on n field the database size climbs to more then 100MB. I have made little changes on query. But it takes long time to execute. Also can I have A1230001... -
K
Increment start number values by group wise row depending on Quantity Of Leaves in Access
I put huge data on the program like 7 digit on number table. But it takes long time to execute or some time it crashes. Is there any other way to increment startno without depending on number field. And if any alpha numeric character added then how it will increment like A1230001, A1230002... -
K
Increment start number values by group wise row depending on Quantity Of Leaves in Access
Dear arnelgp, You are simply great. You solved my problem. Many Many thanks. -
K
Increment start number values by group wise row depending on Quantity Of Leaves in Access
I tried But couldn't solve it. Would you please send me the complete query code. -
K
Increment start number values by group wise row depending on Quantity Of Leaves in Access
Thank you for quick response. I want to repeat the group wise row level value and only start no will increment depending on No of leaves quantity. I have temporary table called number. In query and report everything is ok except incrementing start_no values. -
K
Increment start number values by group wise row depending on Quantity Of Leaves in Access
I am in stuck to make increment startno values by group wise (row) depending on quantity of leaves in Access. I have attached my work. Any help will be appreciated.