Crosstab report problem

[tinker]

hiya, I need to create a crosstab report with a Publication name as the row header and the week date as the row header with two value fields. I have two crosstab queries, (The reason why i have two is because i want two value fields, so i have 1 crosstab query for each value field i need) and then use another select querie to select from both crosstab queries, which in effect gives me one crosstab querie which has two value fields. 1 value field has a cost in it, but the other is an ID field which i was going to use to link to another table (using a subreport as this is a one to many relationship). The problem ive got is that it looks like i might need a subreort for every week of the year (which means ill need 48 subreports), surely theres a better way of doing this, can anybody help me please.

P.S hope this makes sense

 

[Rich]

Download the QrySamp db from the MS Knowledge base, there are several examples.

 

[tinker]

Could you post the link for it please, as i cant find the page. Ive looked for this in the past but have not been able to find it. Thanks

 

[tinker]

Can anybody help me in finding the download for qrysample or even solution.mdb. (I thought solution might of come with office 2000 but its not there).

Thanks

 

[Rich]

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q182568

 

[tinker]

Thanks for your help rich but it doesnt seem to show me what i needed. Can anyone please tell me where i can download solution.mdb because im hoping this might have some good examples.

 

[Sohaila Taravati]

Refer to this posting it might help! http://www.access-programmers.co.uk/ubb/Forum5/HTML/002807.html

Sohail

 

[Rich]

Good though Solutions is you will not find the answer there. Are you sure the queries sample doesn't have an example, there is one showing multiple values.

 

[Pat Hartman]

This is the address of the download site.
http://support.microsoft.com/support/access/content/97downloads.asp?FR=0

The cross referencing on the site leaves much to be desired. Most things will show if you select the version of Access you want plus Win95. But try the other OS' just in case.

Unfortunately, solutions.mdb is not available from there. You need either Access97 or the developer's edition of A2K. Solutions.mdb does not come with the standard version of A2K or A2002. When you install solutions.mdb, make sure that the three help files are also installed since they provide many of the clues you need to understand the examples. (Soltn80.cnt, Soltn80.GID, and Soltn80.hlp)