I am a newbie and have hit the wall.
Book1 table - fields id, Author, isdn, copyright, title....
Availability table - fields sp_id, isdn10, list, new, used, ....
isdn in Book1 table is a 13 character field, that needs to be MID to 9
idsn10 in availability table is a 10 character field, that needs to be Right, 9
The calculated 9 character field should match up but I have no idea how to make it happen. Help!