Dynamic crosstab reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have gone through several posts regarding dynamic crosstab reports and I'm
still confused. I have created a crosstab query that provides an overiew of
the quantity of products delivered to departments during a period. The layout
is as follows:
Department 1 Department 2 etc
Product 1 quantity quantity
Product 2 quantity quantity
etc
You can imagine that depending on the period, several departments will not
appear on the list. How do I create a dynamic report without the familiar
error message appearing when the department does not appear in the
query/report?
Thanks a lot in advance for your help.
 
Jhuny,
Trying to describe how to do a dynamic crosstab report is beyond the scope of newsgroup
email communication.
It's a complicated process, but do-able.

Do a normal Google web search on "Micosoft Access" "dynamic crosstab"
You find several tutorials, and more importantly many sample files with code.
Download and study up on several that you find, and pick one that you feel you
understand, and can follow.
Bring that code into your report, and customize it for your particular needs.

It's a great code learning experience, but does require some "sweat equity"...

for example... among others
http://www.blueclaw-db.com/microsoft_access_reports/
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q328320
 
Dear Al and Duane,
I went through some additional material and was able to get some helpful
information, explanations and codes. Thanks for the advice and links.
Regards,
JB
 
Back
Top