Crosstab query report (with parameters)

  • Thread starter Thread starter Lindsay
  • Start date Start date
L

Lindsay

I am creating a monthly report based on a crosstab query that counts
the number of POs per department, per purchasing agent. I have the
query done, and now I need to know how to create the report. This is
stumping me. I have tried to use the wizard, but it does not seem to
be that helpful. Direction and help on this matter would be great!!!!
 
Creating a report based on a crosstab query is problematic because you may
have different number and names of fields each time. There are some
programmatic solutions to this. You can find a couple here:
http://www.rogersaccesslibrary.com/download3.asp?SampleName=CrossTabReport.mdb
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Cross Tab'

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Back
Top