Hi Folks
I have a problem I need to produce a crosstab query that displays sales
values and sales units for each customer by product code for each month of
the year. Producing a crosstab query for either sales value or sales units
is no problem. So I thought have 2 crosstab queries, 1 for sales value and
1 for sales units and make a 3rd query based on the 2 crosstab queries and
design the layout so that I have Sales value and units together under the
appropriate month. I have 211 records in the underlying table so I want to
see 211 records in the 3rd query that is based on the 2 crosstab queries.
But what do I get? 1039 records.
Anyone had this experience??
johnb