Filling Crosstab column headings from Combo Box list

Hi, reading your post I think you have based the crosstab query on another query which is sourcing the dates from a form. And, I take it the select query based on the form is working ok. If this is the case, can you change the select query into a crosstab query and get what you want that way? Please advise if I am reading your post wrong.
HTH, Andrew.

Hi, it's too late to edit my response but I see I have just given you advice that directly conflicts with advice you received in your previous post.

If you retian the double query set-up, is your crosstab query only referring to fields in the select query? And nothing on the form? If not then this would be the first thing to change - you can pass any field from the select query to the crosstab query and use it as a row heading (even if you use that field as a column heading) so you shouldn't need to refer to the drop down / combo box on the form in the crosstab query.

The second thing to do is eliminate the calculations from the crosstab query and do as many as you can on the select query. If you need a grand total or a subtotal, then you can always do those on the report instead of in the queries. Keep the crosstab query as simple as possible. You might want to build it up from scratch adding one field at a time to work out exactly which part is making it not work.

If none of this helps, can you post some additional details as to the fields in your table(s) and what you would like to see in the crosstab query / report?

HTH, Andrew.