Increment start number values by group wise row depending on Quantity Of Leaves in Access

[gemma-the-husky]

I think the thing is we don't really understand your data and your requirements.

 

[Pat Hartman]

Your request is muddy at best. You really need to clarify the requirements. If you cannot state them in a way we can understand, we can't code for you . Here is a sample database that might help solidify your thoughts. It shows two samples. One with a complex "Number" and one with a simple sequence.

 

[kamrulbd]

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))
ORDER BY tblCustomer.ID, t.n;

Here "Noofleaves" qty depends on nth value of t table. Increment values from "startno" is working.

Many many thanks to all of you.