MS Outlook Forms: How determine max value for field in datasource.
Peter Cumming
Exchange 98
I would like to create a field which automatically generates a unique
identifying code number.
The syntax of this code is based on the value selected in another
field, which has four possible values.
For each case, the code will need to include a sequence number between
1 and 9999; each sequence is exclusive of other cases.
For example
Case 1:
NC-99-0001
NC-99-0002
Case 2:
99-36-0001
99-36-0002
In each case, the last four digits signify the sequence #, with the
preceding characters having other significance.
What I need to do in order to create a conditional increment is query
the underlying data for the highest current value for the given case
and generate the new code number accordingly.
I have no idea how to do this.
Thank you for your help and perhaps both a direct email
and newsgroup posting.
Sincerely,
Peter
pcum...@yahoo.com
--
Below is from the author of this message:
__________________
See a great Internet tool that was 5 years in development.
http://www.FirstClassSites.com
Resume in word format is at above site-click link
at bottom of that screen.