[MS_AccessPros] Increment Number

 

I am trying to change a field type so that the Number increments 1 for each new record. After I go to Query Design, Close Table box, Click Data Definition and type in

"Alter TABLE tbl_Items Alter Column BoxNumber COUNTER (1000,1)"

I get the error "Invalid Field Data type"

How can I fix this? I've tried changing the Data Type using Number and Text, but both result in the same error.

Thanks,
John

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 9
• New Files 5

Visit Your Group

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___