But I try not to think with my gut. If I'm serious about understanding the world, thinking with anything besides my brain, as tempting as that might be, is likely to get me into trouble.
I'm trying to use a parameter in a query. The [message] parameter works for a select query but not the ribbon parameter. When I turn the select query into a crosstab query nothing works except hard coding the criteria.
Select query
Crosstab query
This is the result I want.
Select Query Cross tab Query
Hard code Ok Ok [message] Ok every month for every year Ribbon Parameter every month for every year every month for every year
Thanks in anticipation
John Campbell
@Reply 2 years ago
Your upstream query must be turned into a make table/append query. Then that table is used for the cross tab query.
This will work, but if new fields/values are used in the make table query, then that will affect your crosstab query. For example, if you run the make table and have dates, then those dates are turned into cross tab columns Ja, Feb, Mar, then if you run it again and there are no values for Mar, then your cross tab table will not have it the next time you run it. A hassle if you have a report with those fields. There is a work around though... Create a table with all 12 months, then join this into your crosstab query and do an outer join, showing ALL months in the Months table....
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
