關於Access

想請問一個問題耶,

如果我有一個Data,它的編號可能是A1, A3, A4....

B1, B2, B3, F2, F3, F4....等等含文字的編號方式,

我要怎麼在Access裡設定當搜尋記錄1的時候它就會跳到編號A1, 2就等於A3...以此類推,9就是F4,這該怎麼處理呀,有點小急耶

1 Answer

Rating
  • 1 decade ago
    Favorite Answer

    1)打開資料表設計檢視_新增一個欄位_名稱_序號

    2)在該欄位依序_

    A1, A3, A4.B1, B2, B3, F2, F3, F4....

    1,2,3,4,5,.........

    3_完成上述當搜尋記錄1的時候它就會跳到編號A1, 2=A2.....

    希望有幫上忙.

    2010-05-11 23:40:11 補充:

    2)在該欄位依序_

    A1, A3, A4.B1, B2, B3, F2, F3, F4....

    1,2,3,4,5,.........<==自行輸入資料

Still have questions? Get your answers by asking now.