Cross Tab Dynamic Report Error__Seeking Help! (1 Viewer)

paulcherianc

Registered User.
Local time
Yesterday, 21:19
Joined
Aug 15, 2013
Messages
86
:banghead:
Hi..

Am just a beginner in Access. Trying to do a Cross Tab Query Dynamic Report as you can see in the attachment. I tried with a sample coding got from another website and tried to adapt the same in my crosstab query. But I have few issues:

1. When I am running the report from the form named "Job Card", it gives me an error " Too Few Parameters. Expected 2." - I really don't know how to fix it!!

2. I don't how to show my values in my report. I mean the VBA coding.

Could anyone help me in this. You may try refurbishing my attached file or can share your ideas.

Thanks a ton in advance!

Regards,
Paul C
 

Attachments

  • Cross Tab Dynamic_Paul.zip
    263.3 KB · Views: 159

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 12:19
Joined
May 7, 2009
Messages
19,229
here is the fix.
 

Attachments

  • Cross Tab Dynamic_Paul.zip
    263.3 KB · Views: 152

paulcherianc

Registered User.
Local time
Yesterday, 21:19
Joined
Aug 15, 2013
Messages
86
Dear Arnel,

Thanks for your quick response. But still i am getting the same error message while click on preview button. Could you please look into it again if possible!
:)
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 12:19
Joined
May 7, 2009
Messages
19,229
sorry forgot to update the zip file.
 

Attachments

  • Cross Tab Dynamic_Paul.zip
    238.1 KB · Views: 160

paulcherianc

Registered User.
Local time
Yesterday, 21:19
Joined
Aug 15, 2013
Messages
86
Oh ok it's fine. However I have two other concerns :

- Column headers are not displaying and
- Values are not appearing in the report.

Could you kindly look into it and let me know the wrong things from my end!

God Bless!
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 12:19
Joined
May 7, 2009
Messages
19,229
try again please.
 

Attachments

  • Cross Tab Dynamic_Paul.zip
    199.5 KB · Views: 167

paulcherianc

Registered User.
Local time
Yesterday, 21:19
Joined
Aug 15, 2013
Messages
86
Thanks a Million Arnel!!! You made my day! :)

God Bless!
 

Users who are viewing this thread

Top Bottom