Splitting Fields 1

[Poweruser99]

I have created a cross tab query.

One of the field has both the 'new units' and 'total price' in it. It is a concentated query.

However in the report I would like to split these fields into 2 seperate ones, and I am very poor with functions. Any help would be appreciated.

 

[glalsop]

Why not just make them 2 fields in the query?

-Gary

 

[Poweruser99]

Because they are part of a crosstab query and in a crosstab query you can only have ONE value field. I need to display 2 value fields, and this was the easiest way to go at it.

 

[glalsop]

1) Sure you can have multiple value fields in a crosstab query:

http://support.microsoft.com/?kbid=209143

This really would be easier than splitting the fields after the query runs.

-Gary

 

[Poweruser99]

Thanks a Million glasop!! Ure the man!~!!