killerflappy
Registered User.
- Local time
- Today, 12:35
- Joined
- Aug 23, 2017
- Messages
- 50
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?
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?