Crosstab query and reports

[meridian]

Can anyone help with the following,<br>

<br>

I have created a cross tab query of products and weeks.<br>

The weeks are dependant on a user selection. This means that I can never be sure of which weeks will be selected. The products are also variable depending what is in production each week.<br>

<br>

How can I work this into a report as I seem to require one constant for the report to reference ?.<br>

If I pick weeks the products will vary, if I pick products the weeks will vary and it is not practical to pick both.<br>

<br>

Hope someone can help !!!

 

[DougP]

Well if you are not in a Cross tab query you can pick more than one constraint.<br>
i.e. Weeks and Products.<br>
So try making a new query, leaving your original alone for now.<br>
See if you can get some of the info you need. <br>
Starting with Products or Weeks first than add the other.<br>
There are other ways to get the information without using a Crosstab.<br>
I suppose your final result is some kind of Report?<br>
you can do some powerful things in the report side. <p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[elizabeth]

A dynamic cross tab query involves a significant amount of work and VBA code. There is a complete example with code in A. Balter's &quot;Mastering Acces 97&quot; on page 440. It's quite lengthy. It worked great for me. There's also an article at <A HREF="

http://support.microsoft.com/support/kb/articles/Q103/2/62.asp"

TARGET="_new">

http://support.microsoft.com/support/kb/articles/Q103/2/62.asp</A><br>

This looks similar. It is old so it may need updating.