Differences in record formats / same data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I have two tables that contain Serial Numbers. One of the tables is a
five digit number. The other table is eighteen digits, zero filled until the
last 5 digits. Is there any way I can change the format of the zero filled
table so that the same Serial Numbers can be recognized?
 
Hi. I have two tables that contain Serial Numbers. One of the tables is a
five digit number. The other table is eighteen digits, zero filled until the
last 5 digits. Is there any way I can change the format of the zero filled
table so that the same Serial Numbers can be recognized?
Click to expand...

The *format* of the field is irrelevant: it only controls what's
displayed, not what's stored. Does the first table have the serial
number in a Number field, or a five-character Text field? I presume
the second table has an 18-character Text field? Do you want to alter
the contents of the second table so instead of "000000000000021345" it
contains "21345", or do you want to leave the tables alone and
dynamically join them?

John W. Vinson[MVP]
 
Hi John,

Actually both table serial numbers are currently 255 character text fields.
This data was imported from excel spreadsheets.

I would prefer to alter the content of the second field as the zero fill is
not necessary. I have many records, so I don't want to take the time to alter
them manually.

I need to have each of the tables recognize each other's serial numbers for
a union of data relative to the S/N.

Any help you can give is greatly appreciated. Thanks!

Staci
 
I would prefer to alter the content of the second field as the zero fill is
not necessary. I have many records, so I don't want to take the time to alter
them manually.
Click to expand...

Ok... run an Update query updating [fieldname] to

Right([fieldname], 5)


John W. Vinson[MVP]
 
Thanks John!

John Vinson said:
I would prefer to alter the content of the second field as the zero fill is
not necessary. I have many records, so I don't want to take the time to alter
them manually.
Click to expand...

Ok... run an Update query updating [fieldname] to

Right([fieldname], 5)


John W. Vinson[MVP]
Click to expand...
 
Back
Top