Count from tables

J

Jez

Hi, I am not sure if I'm being thick or not but I am struggling with this.
I have a table with Product and their costs.
I have another table with Products bought when and who by.
I am trying to bing together in a query a list of how much has been spent on
each product.
This query looks like this...
[BoughtWhen] [Who by] [Product A] [Product A Cost] [Product B] [Product B
Cost]
How can I do this in a query?
Jez
 
S

Stefan Hoffmann

hi,
Hi, I am not sure if I'm being thick or not but I am struggling with this.
I have a table with Product and their costs.
I have another table with Products bought when and who by.
Click to expand...
First of all, you need a query collection these columns. Just put the
two tables in it, use the correct join and choose your columns.
I am trying to bing together in a query a list of how much has been spent on
each product.
This query looks like this...
[BoughtWhen] [Who by] [Product A] [Product A Cost] [Product B] [Product B
Cost]
How can I do this in a query?
Click to expand...
Create pivot query with the assistant based on the previous created query.


mfG
--> stefan <--
 
Top