Count from tables

[Guest]

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

 

[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.

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?

Create pivot query with the assistant based on the previous created query.


mfG
--> stefan <--