98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Cross Tab report with Parameter
Cross Tab report with Parameter
Resolved · Medium Priority · Version 2003
Fri 19 Dec 2008, 10:29Delegate Lu said...
Lu has attended:
Access Intermediate course
Excel VBA Intro Intermediate course
Cross Tab report with Parameter
Hi I'm trying to build a report from a cross tab querie, and the querie has two parameter, start date and end date. When I select the querie in report wizard, there is nothing selectable from the cross tab querie. I tried without a parameter and it worked. Any idea how to get the parameter work with the report please?
thanks.
Lu
Mon 12 Jan 2009, 11:05Trainer Rajeev said...
RE: Cross Tab report with Parameter
Dear LU
Thank you for attending Access Intermediate Course!! I hope you enjoyed the course and benefited from it.
The answer to your query is not a straight forward one. This requires a bit of understanding of the VBA code. Instead of me going through this step by step with you I would recommend you to refer to the following link:
http://support.microsoft.com/default.aspx?scid=kb ;en-us;328320
The good thing is that it also uses the same fields that you are looking for.
If the link helps you in answering your query then well and good if it doesn
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Zoom feature for queriesIf youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field |
