Linked table - strip off zeroes 1

[lmontes]

When I link a table, the leading zeroes are stripped off a field.
How can I stop this from happening?

 

[BNPMike]

Just create a query on the table which puts them back. Yet another reason for always using queries and never base tables.

 

[Hosacans]

I have a similar problem with zip codes, i try to add zeroes in front of a field that had been removes after importing the data. what syntax do i use in a query for that...

ex:
original data = 08801
actual field [zip] = 8801

desired field [zip] = 08801

- some records have been truncated into 3 digits due to the nature of the zip code, how can i check/differentiate the [zip] field from 3,4,or 5 digits zip codes. I think i should use the LEN() function but i dont know how to embed that into a if/conditional statement...

please help

Thanks
Kin

 

[PHV]

Right("0000" & [zip], 5)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Hosacans]

wow... that is very clever and simple...

i didnt even think of that... hehe

THanks so much for the quick response
Kin