Crosstab querie problem (1 Viewer)

[tinker]

Hiya.
I need to create a report, which i suppose would best be done using a cross tab querie.
Below is my crosstab querie
The following fields are to be taken from two tables
The row header i want as the Publication field, e.g Tatler, Vogue. (from table 1)
The column header i want as the Date field, with the setting set to month so it prints with headings as Jan, Feb etc. The value field is Estimated value and is taken from table two.

Im capable of doing the above but the problem ive got is that for example if the vogue has two entries for Jan, it sums the estimated costs, but i want two seperate entries i want it to look like this

Jan Feb Mar Apr etc
Vogue 10 5 8 4
Vogue 4

But its doing this

Jan Feb Mar Apr Apr etc
Vogue 14 5 8 4


Any ideas. Cheers

 

[Pat Hartman]

You need an additional column as the Row Header. Use whatever column is causing the two entries in your base table.

 

[tinker]

Thanks for your help but its still not giving me the desired results.
What ive done, Ive included AD ID as a row header, this is a unique ID.
The problem ive got now is that every record is now on a different line

Please Ignore the dots

.......Jan...Feb...Mar...Apr...etc
Vogue..10
Vogue.........5
Vogue...............8
Vogue.....................4
Vogue...4

Please tell me if im doing something obviously wrong

Cheers.

 

[DBL]

Have you based the Crosstab on the results of another query? You may need to create a select query and use the GroupBy to get the results you want, you can then base the Crosstab on that query

 

[Pat Hartman]

What additional column is it that you want to group by? Publication is too high a level and AdID is too low. By what criteria are you determining that Vogue should have 2 rows? What ever it is, THAT is the column you need to include.