I'm trying to create a form that would be based on a crosstab query (I'm using the form wizard to do this). However, when I select the crosstab query to be the recordsource, there aren't any fields available to be selected. After thinking about it, I figured out that there aren't really any fields that the query has. It is just data being placed in the field names. However, realizing that hasn't gotton me any closer to figuring out how to get a form to be based on the crosstab query.
-
-
As you pointed out, the field names are the wonky part for the crosstab query within a form; however, Allen Brown has suggested that this is still possible by predefining the column headings: ([crosstab query techniques: Column Headings.
Now I must admit, I've not done this myself within form, usually I send CTQ to a report or export them out to Excel as the graphing is a tad nicer than within Access, and CTQ are a weak point in my Access toolbox (however, much improved with the help of the other Experts here at Bytes!!). -
That did it Z. Thanks!Comment
Comment