Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Crosstab queries


Message #1 by "joh bell" <johnwardbell@a...> on Sat, 31 Aug 2002 13:33:19
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 

  Return to Index