Recent content by MG5020

I would like it as a single expression. The names will be different, i.e. John Smith 100.00 210.00 180.00 320.00 Bob Jones 95.00 188.00 170.00 300.00 John Q Public 125.00 250.00 220.00 400.00 I have never used a crosstab query so I don't know if this is what a crosstab query looks like. Mark

I need to do it in a SQL statement, not in VB code.

Hi, I have a table that has the following fields: Name Rates Tier What I would like to do is display the table based on the name, rates, and tier type. For example I would like to display this: Name Rates Tier ----------------------- John Smith 100.00 Indiv John Smith 210.00 2Party...