O
Orlando
Hi all,
I have two tables. One is an Invoice data, which has over 100 columns, and
the other one is the itemized pricing, which contains different products and
their pricing (there can be only one of each kind of product in each
invoice). One record in the first table will have 20-50 records on the second
one. I need to be able to query one particular invoice, and have all the
fields from the invoice table, plus each product code as a column heading,
and each price as the value.
In total there are too many products on the product table to have a crosstab
query and then connect the two tables together, so what I did was create a
crosstab query with the columns of the invoice table set as row headings, the
different product codes as column headings, and then the average (which
should be only one record) price as the value.
This works fine when I'm using just a couple of fields from the invoice
table, but for some reason values start disappearing when I add fields, until
all the invoice fields appear, but all the individual products' price is
blank.
Doen anybody have similar problems?
Thank you.
I have two tables. One is an Invoice data, which has over 100 columns, and
the other one is the itemized pricing, which contains different products and
their pricing (there can be only one of each kind of product in each
invoice). One record in the first table will have 20-50 records on the second
one. I need to be able to query one particular invoice, and have all the
fields from the invoice table, plus each product code as a column heading,
and each price as the value.
In total there are too many products on the product table to have a crosstab
query and then connect the two tables together, so what I did was create a
crosstab query with the columns of the invoice table set as row headings, the
different product codes as column headings, and then the average (which
should be only one record) price as the value.
This works fine when I'm using just a couple of fields from the invoice
table, but for some reason values start disappearing when I add fields, until
all the invoice fields appear, but all the individual products' price is
blank.
Doen anybody have similar problems?
Thank you.