Cross Tab Dynamic Report Error__Seeking Help!

[paulcherianc]

: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

 

[arnelgp]

here is the fix.

 

[paulcherianc]

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]

sorry forgot to update the zip file.

 

[paulcherianc]

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]

try again please.

 

[paulcherianc]

Thanks a Million Arnel!!! You made my day!

God Bless!