Query Result Export

[worldwidewall]

Hi

I am running access 2003.

I have created a query and I can run it and get the right results. I want to copy the results and create an Access table. I know that I can use a 'make table query' but it will not let me because I have more than one primary key in the query reults. This probably means I am breaking some database best practices but there must be a way to export the query results to a new Access table?



Thanks

Dave

[aytee111]

Queries don't have primary keys, only tables do. What is the exact error you get when you try to run your make table query?

[worldwidewall]

Hi aytee11

The error is:

Resultant table note allowed to have more than one autonumber field.

Thanks for your time

Dave

[aytee111]

OK, this is interesting. I presume you need to keep those values in the new table? You can change them to ordinary numbers: NewFieldName:CLng(pkfieldname) - this will change the data type from Autonumber to plain Number.

[worldwidewall]

Yes i need them in there for future reference.

Are you saying I can change them to ordinary numbers in the query itself? Or do I have to go back to the table design in the backend?

Thanks

[aytee111]

No, that statement I gave you is what you put in the Field column in the query.

[worldwidewall]

Thank you, that worked perfectly.