J
julzc_07
How do I run a crosstab query to give the product of two fields as a single
output in the datasheet view?
ie: Product ID is the row heading, customer ID is the column heading, and I
want to fill in the table with unit price of each product multiplied by total
quantity of product each customer ordered in order to find total cost of each
order for each customer.
output in the datasheet view?
ie: Product ID is the row heading, customer ID is the column heading, and I
want to fill in the table with unit price of each product multiplied by total
quantity of product each customer ordered in order to find total cost of each
order for each customer.