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.

 

[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.