Crosstab in a form

[Gismo]

Hi all,

Is it possible to have a crosstab query in a form?
When the crosstab query gets added coulombs as the data changes or added, such as months, how will this be automatically be added in the form as the form are set in the controls created

 

[theDBguy]

You can display a crosstab query as a query in a subform. Otherwise, you'll need some code if you want to use other controls.

 

[Pat Hartman]

By using the query itself as the subform (drag the query onto the main form), you force Access to build a form on the fly and so new columns are not a problem. Of course you get no control over the format but that's the trade off.

It is possible to handle a form bound to a crosstab but it takes some code. The only limitation is that you have to fix the width of the form at design time so you are limited to the number of columns that are selected. If you potentially have more than will fit on 22.75 inches (max form width), you will need to export to excel. Your crosstab is limited to 255 column though.

If you need the sample of naming the columns on the fly, here's a link.

Bound Denormalized Form

I've left the old versions here but ALWAYS go to the last post to get the current version. This database contains two examples (using the same technique) of how to take data that is properly normalized and display it so that it looks like a spreadsheet (rows displayed as columns) but is...

www.access-programmers.co.uk

 

[Gismo]

Hi all,

Any reason why the cross tab query on a form would display as below?

I have to click click on the + first to display the query

 

[June7]

I tried dragging a CROSSTAB query onto a form and Access does not allow this for any table/query. I have to first install subform container control and set its SourceObject property to CROSSTAB query. Was table/query drag and drop added to versions after Access 2010?

 

[Gismo]

I tried dragging a CROSSTAB query onto a form and Access does not allow this for any table/query. I have to first install subform container control and set its SourceObject property to CROSSTAB query. Was table/query drag and drop added to versions after Access 2010?

Yes I am using 2016

 

[Pat Hartman]

When I drag on a crosstab, the wizard automatically creates a form.

 

[Gismo]

When I drag on a crosstab, the wizard automatically creates a form.

Thank you
Did not know It would automatically create a form
I first created the form then dragged the query

But dragging the query onto the main form worked well