How to save that number...

Results 1 to 2 of 2

Thread: How to save that number...

  1. #1
    Join Date
    Dec 1969

    Default How to save that number...

    It might be a waste of time but I want to be sure...<BR><BR>I have a list of states and when a user pick one I&#039;m saving the ID of the state. My question is if I should define in Acceess that the field is a number or text?<BR><BR>Thanks!

  2. #2
    Join Date
    Dec 1969

    Default Since US states all have...

    ...a simple 2 character (and guaranteed unique) abbreviation, why would you use anything else?<BR><BR>Even Washington, D.C., ("DC") and Puerto Rico ("PR") are in there. So use a fixed char size of 2 for the abbreviation. And that&#039;s the same size on disk as an integer. So it&#039;s just as efficient as an unreadable number.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts