Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Lv 2264 points

outta luck

Favorite Answers100%
Answers1

  • Char(n) SQL data type equivalent in Microsoft Access?

    New to access here. I need to have a field in a table of integer value maximum length 2 characters. I was hoping Access would prefix a 0 (zero) to the attribute when it only was comprised of one character. Any suggestions??

    For example, I enter the value 2 in a field, and I would like it to be store as 02 to facilitate concatenation with another field.

    Kind regards, and many thanks.

    3 AnswersProgramming & Design1 decade ago