[MS_AccessPros] Re: Increment Number

 

I tried using an AutoNumber but the error says "Access allows only one autonumber field per table"

I tried using Text data type, Number data type, nothing works.

Any other ideas?

Thanks for any help.

John

--- In MS_Access_Professionals@yahoogroups.com, "Clive" <zctek@...> wrote:
>
> Hi John,
>
> The FieldType must be of Type: AutoNumber which you
> can select from the DropDown in the 2nd column of the
> table in DesignView.
> It will create FieldSize of LongInteger.
>
> If you link to an AutoNumber field then the linking
> field must also be a LongInteger.
>
> Regards, Clive.
>
> --- In MS_Access_Professionals@yahoogroups.com, "yshopper" <jlinux@> wrote:
> >
> > 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 (3)

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

.

__,_._,___