cross-table query not shown correctly in table from make-table query

[killerflappy]

I’m a beginner in making Query’s (and SQL).

In the Example file there is a cross table query (qryCountPerStore) with the information I need.
I want this information in a table. I do this with a make table query (Kopie van qryCountPerStore).
The table thas is made (tblqryCountPerSore) is not shown correctly. I see the products (A, B and C) are counted per row per store. I want the table to show the count of A, B and C on 1 row. Just like the qryCountPerStore.
So how can I get a table with the result of the qryCountPerStore?

 

[plog]

Then make a MAKE query out of qryCountPerStore.

However, why must this data be a table? Why not just use qryCountPerStore?

 

[static]

A query can't be 2 things at once.
It can either be a crosstab or a maketable.

You can use one query inside of another (different type of) query though.

select * into newtable from qrycountperstore

 

[killerflappy]

However, why must this data be a table? Why not just use qryCountPerStore?

I copied the query and convert it to a make table. Then I convert it to a make table. So I have to test if a new make table does the trick. Thanks.

I need to change some data by human interaction.

 

[killerflappy]

A query can't be 2 things at once.
It can either be a crosstab or a maketable.

You can use one query inside of another (different type of) query though.

select * into newtable from qrycountperstore

Yes! this does the trick. Thanks quys!