Max,
My requirement is as follows, hope u can understand
Date_____ Cust QuoteR
1-Oct-08 4628A 001
1-Oct-08 4670B 001
1-Oct-08 4628A 001
15-Oct-08 4628A 002
15-Oct-08 4670B 002
15-Oct-08 4670B 002
16-Oct-08 4628A 003

Vijay DSK
"Max" wrote:

.. my actual situation is there will be
more quotations on a single day per customer

Can you show how then should the quote refs be generated?
Take the sample data below for 2 customers, indicate in your reply:

Date_____ Cust QuoteR
1-Oct-08 4628A
1-Oct-08 4670B
1-Oct-08 4628A
15-Oct-08 4628A
15-Oct-08 4670B
15-Oct-08 4670B
16-Oct-08 4628A

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
---