There are several ways but it usually needs a temp table. Post your crosstab
SQL and sample data.
--
Build a little, test a little.


"Kingsoft" wrote:

I am atempting to use the crosstab query to display a series of data across
various dates, but can only get one value field of data to work. Is there a
way to display more than one value field?
--
kingsoft