Ok ill try to keep sweet and easy to understand.I have a table that has a field called Order Number and End date.
Order number: txt file example: RR0052 (always has RR+4 digit number)
End date: is just a date, example: 09-Sep-09
So this is what i am trying to accomplish(notice i am only intermediate ms user)
1. Order number= RR(Current number +1) per row
2. Once a new fiscal year hits(like 1 oct 09) It restarts the number to 001
3. once a new fiscal year hit, any end date that has past is hidden(or taken out, just not deleted)
So for example:
I have
Order Number----End Date
RR0051----------1 Mar 09
RR0052----------19 Jul 09
RR0053----------20 Aug 09
RR0054----------7 Oct 09
RR0055----------5 Sep 09
Today 1 oct hits,
it would show:
RR0054----------7 Oct 09
RR0001----------blank line, and any new lines get +1 to number.
I know this is possible, just dont know how to implement the fiscal year thing and +1 to number. I am guessing a macro will have to be used.
Please let me know, and maybe some example code or some instructions..
Thank you.
