reports help

[sweeethrdt3]

I have a data table that looks like this:

Date
Product
Product ID

There are multiple product ID's for the same product and
date (1/1/03, phones, 1234; 1/1/03, phones, 2345)

I want to create a report that shows the date in the left
most column, the product types in the top column and the
ID's under each product. Because each date, product and
product do not have equal values, I get multiple values in
the report field. Any suggestions?

 

[Duane Hookom]

There are many crosstab report samples at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. There should be
something there that meets your needs.