ISBN numbers are given to publishers by the International ISBN Agency ( see http://www.isbn-international.org ).
But for calculating the number from your own article numbers, this function can come in handy.
Four unique fields - data is auto-entered or validated to be unique? Text Fields? Number Fields?
The Calcuation field result is Number? Text?
Error Messages are??
Do you want a list or a result of SectionSubSectionPieceCase (001002003004)
Home > Designing and creating databases > Creating a database > Defining database fields > Defining calculation fieldsDefining calculation fieldsUse calculation fields to perform calculations on the following types of data: text, number, date, time, or container.The data in a calculation field is the result of a formula that you specify.
The result can be one of these types of data: text, number, date, time, or container.
Note that a list function returns the values with a return separating each one--Don't think that's what you want to get an ISBN.
the data is hand entered. each field has four characters. I'd like them to appear xxxx-xxxx-xxxx-xxxx in the calc field if possible. I can't even get it past the scripting step.
Field1 & "-" & field2 & "-" & field3 & "-" & field4
Thanks phil. I appreciate the help as always!