Hi folks, I've been messing with this for a while and just can not figure it out - hope someone out there has a better clue than I.
SELECT Name FROM List WHERE Category IS Email Ok - this should provide me with a set of X (let's say x=10) amount of records. The result I am looking for is to then select a random subset of Y (let's say y=3) records from this X set. Any ideas? Btw - I'm using a simple Access DB here. Many thanks in advance. Sincerely, Craig S. Kiessling >From: "imogenkhan imogenkhan" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: SQL <[EMAIL PROTECTED]> >Subject: RE: autonumber >Date: Fri, 09 Nov 2001 05:59:39 +0000 > >Thanks man! > > >From: "Maia, Eric" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: SQL <[EMAIL PROTECTED]> > >Subject: RE: autonumber > >Date: Fri, 2 Nov 2001 13:55:53 -0800 > > > >In MS SQL Server, use > > > >Group_id int identity (1,1) not null > > > >Eric > > > >-----Original Message----- > >From: imogenkhan imogenkhan [mailto:[EMAIL PROTECTED]] > >Sent: Friday, November 02, 2001 1:52 PM > >To: SQL > >Subject: autonumber > > > > > >I'm trying to create a table in MS SQL Server: > > > >CREATE TABLE OPTgroups > >( > >Group_id auto, > >Organizer varchar(50) NOT NULL, > >Group_name varchar(50) NOT NULL, > >Group_number varchar(4) NOT NULL, > >Flight1 varchar(4), > >Flight2 varchar(4), > >CONSTRAINT group_id PRIMARY KEY (group_id) > >) > > > >I'm trying to make Group_id an autonumber that will automatically >populate > >with every new record thats inserted. But I keep getting > > > >Server: Msg 2715, Level 16, State 7, Line 1 > >Column or parameter #1: Cannot find data type auto. > > > >How do I remedy this? > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
