dbaker5204
Registered User.
- Local time
- Today, 16:59
- Joined
- Jan 19, 2018
- Messages
- 20
I used a cross tab query for the main report as I was showing values month over month. I created a cross tab query with the Month to Date totals that I wanted to use as a sub report but I get an error that says "You cant use a pass-through query or a non-fixed column crosstab query as a record source for a subform or sub report".
Well the nature of the report does not permit me to used fixed columns. So I am wondering if there is another way to get this data to show the way I want it to. I included a screenshot of the report...if any other info is needed, let me know.
Well the nature of the report does not permit me to used fixed columns. So I am wondering if there is another way to get this data to show the way I want it to. I included a screenshot of the report...if any other info is needed, let me know.