Yes, the auto-number is the Primary Key.
All I need to to auto-increment a number field from 1 up to 1000. My
client wants a sequential Box Number for each box shipped. If there's a
better or easier way to achieve the same result, please let me know.
Thanks.
On 11/26/2011 1:07 AM, John Viescas wrote:
>
> 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%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>] On Behalf Of yshopper
> Sent: Friday, November 25, 2011 11:59 PM
> To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.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
> <mailto:MS_Access_Professionals%40yahoogroups.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
> <mailto:MS_Access_Professionals%40yahoogroups.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
>
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar