Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Cross Tab report with Parameter

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Cross Tab report with Parameter

Resolved · Medium Priority · Version 2003

Reply 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

For upcoming training course dates see: Pricing & availability

Reply 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

Access articles

· Want To Find Out About Access Queries?
· The Benefits of Certified Microsoft Training in Access
· Discover the Secrets within Your Business through Microsoft Access Training
· Find Out About The Join Property In An Access Query
· How much time could you save with Access?

Please browse our web site to find out more about
microsoft.access.courses and other Microsoft training courses.

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown

View all Access hints and tips