[AccessD] Flattening the results of a query

This has been a real 'duh' moment for me.
As usual, the best answers are always 
the simplest.  

Many thanks Erwin

Stephen Bond


P.S. 
Quote on the dba-SQL Server 
thread in January: 

   "I hereby withdraw any implied claims 
    that I know my tools :-) "
  
To which I add, me too.

SB


-----Original Message-----
From: Erwin Craps [mailto:Erwin.Craps at ithelps.be]
Sent: Saturday, 6 September 2003 7:43 p.m.
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Flattening the results of a query



You should use a cross tab query.
This is the way to go.
Two limits with crosstab.
No more than 256 (or something) products.
Only one value (product in you case) per query

This is pretty easy, sorry for not giving you a sample.
Create new query choose crosstab

Erwin