John-
The COUNTER data type is the equivalent of the Access AutoNumber. Do you
already have an AutoNumber in the table? If so, what is its purpose?
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of yshopper
Sent: Friday, November 25, 2011 11:59 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [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
> >
>
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar