Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004

    Angry Unanswered: change fIELD tabLE to numeric????

    Hwo To Change Field Into Numeric Wehn It Is Textnumeric But Its All Numbers Not Text Involve In It ..its Just Reading As Text
    Last edited by njptown20; 09-28-04 at 17:56.

  2. #2
    Join Date
    Feb 2004
    If you open your table in design view, you can change the field data type to numeric, or Number as its called in Access. This will convert the text values to numeric values when you save the table. If the values won't convert you'll get some errors, so create a test table to try this on first. If you have relationships defined to the field you can not convert it without first removing the relationship.


Posting Permissions

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