Crosstab query on form?

Hi - is it possible to display a cross tab query in form view?  I'm trying to keep my users with switchboard access only rather than having them search through the core queries etc. to find this and I'm having a heck of a time getting to go on a form...it keeps erroring out.  Thoughts?  Thanks!
daisypetals313Asked:
Who is Participating?
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
daisypetals313,

  "I'm trying to keep my users with switchboard access only rather than having them search through the core queries etc."

Then another option would be to make a crosstab query "Menu", and then make this menu a choice on the switchboard?

Sample attached

JeffCoachman

Access-EEQ24332825CrossTabQueryI.mdb
0
 
TextReportCommented:
If you are using a crosstab query then almost certainly you will need to use FixedColumnHeadings in order to use this in a Form Or Report, exspecially if your query is using variable date such as dates where not all fields are used.
In 2007, not sure about 2003 you can use a Pivot Table rather than a cross tab.
Cheers, Andrew
0
 
Jeffrey CoachmanMIS LiasonCommented:
;-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.