Adding an index field in a make table query

[Torq]

Hi all,

Okay I'm fairly new to Access, so this may be real simple, but I couldn't find any answers in the Access help.

I have a table with a list of products in: Products

I want to run a query which will create a new table (Albums) with only products from a specific department. What I would also like to do is in the newly created table have an Index field which would auto number all the products, so I can select a specific amount eg top 50 or so using other queries.

Is there a way to create a brand new field in a make table query?

Thanks in advance,

Simon

 

[namliam]

There is a way to create a new field with a maketable but not to create an autonumber field.

This however can be done using an alter table query (Data definition language) or using your own autoincrementor

Regards

 

[Torq]

Thanks namliam, I've had a look at that Alter Table data definition language stuff, but its a bit beyond me at the moment. Also I have no idea what an 'autoincrementor' is.

I've been thinking maybe there is an easier way to do what I'm after.

I have a table derived from a make table query, and I would like to run another make table query on that that gives me the first 50 records as a new table.

Is there an easy way to do that?


Thanks in advance,

Simon

 

[Torq]

Aaargghhh!!

So simple I didn't even see it, I eventually noticed the little box on the toolbar that lets you specify the number of records you want. Solved all my problems in about 5 seconds.

Such a dunce


Simon