truncating data

[NPI]

I import data from an excell file into a table. The date field comes in as
1070807 (1,yy,mm,dd). I want to just us the last 6 digits or places. Can
make the field text or number.

 

[ruralguy via AccessMonster.com]

Right(Trim([YourField]),6) should do it.

I import data from an excell file into a table. The date field comes in as
1070807 (1,yy,mm,dd). I want to just us the last 6 digits or places. Can
make the field text or number.