from query to table

[ElastoManiac]

How to convert a query to a table?

 

[seth_belgium]

Change the type of query to a CREATE-query (I don't know how it's called in English...).

It's the third thing in the list, right under the CROSS-table query.

If you select it, it'll ask you for a name for the table. Give it one and simply run the query. There you go, your query becomes a table.

Seth

 

[ElastoManiac]

i don't get this really...
can you explain it step by step?

 

[ElastoManiac]

I found a way to solve this:
I create a table with exaclty the same structure as query.
Than i copy all data from query to my new table.
(CTRL+A)

 

[Rich]

Why would you want to save the data from a query to another table?

 

[ElastoManiac]

it's a long story...

 

[seth_belgium]

In the attached example you can see an example of the type of query I was talking about.

But also check out the form I made for this (I'm proud of it ). You can use this in your database if you want, simply import the form (you don't need the query) and start copying!

Greetz,

Seth