I have a problem with a report that I am suppose to make that would look like a table from MS Word. What I have is an Access table that has an ID, the Client, the date of the sale, the furniture line sold(Company), and GrossSales. What they want is a table that looks like this:

CLIENT NAME……………………………..DATE………………………………................


DessinFournir 2000 2001 2002 2003 2004 YTD
Gerard
KerryJoyce *GrossSales in here for each year and company
ClassicCloth *for this Client
PalmerHargrave
.................................................. ............................................
^
above are Furniture lines

While I can easily make a crosstab query that has Client and Company as row headings and OrderDate by year as column heading and SumOfGrossSales as Value, it only displays the furniture line or lines that the Client has bought in this 4 year period--I have no way to set up a table to display like this on a report and just put SumOfGrossSales in the appropriate boxes for each Client instead a varying amount of lines according to what furniture line the Client bought. I can also easily have a Client header so that the report sorts by Client so that is not an issue.

Thank you in advance for your time and responses.