Chart On A Form With Crosstab As Data Source Sorts Weird, Access 2016
Apr 20 2017, 03:36 PM
Joined: 20-April 17
I have a form with no data source. On it are 2 charts, each of them have a data source of a crossstab query using a QueryByForm method for criteria. The main form has the controls (dates for start and end) that are the criteria.
Everything seems to work fine for awhile and then at one point the filter method still seems to work but the data becomes resorted.
I have attached a screenshot of the issue where the upper chart has been "fixed" and the lower chart still is sorted improperly. I can't reliably determine what causes the resort.
The "fix" is to edit the chart, change the the chart series to be "by row" and then back to "by column" and then it sorts property.
If I compile the front end it still is sorted improperly.
I have uploaded the front end (FrontEnd.accdb) and backend (Well Data.accdb). you will have to relink the tables to get it to work if you want to take a look at it.
The form is Charts.
|Search Top Lo-Fi||30th April 2017 - 11:37 AM|