Perplexing scatter chart x-axis problem

[whatwouldmattdo]

Hey guys,

just have a quick question about an absolutely infuriating problem I've been facing and I hoping that someone might have come across it before..

I have a table of data where two tests (density and temperature) are taken daily at a brewery ("Fermentation Tests") and are related by a "Fermentation" which contains information about the batch. There is a select query that figures out how many hours the batch has been fermenting when the test was taken, and the density and temperature at each point.

Anyway this graph has worked flawlessly (attached jpeg "Working OK.jpg") until I upgraded to Access 2010. Since then the graph module doesn't seem to pick up the x-axis - even when saved, rearranged etc it just ends up plotting without an x axis (as categories?, see attached jpeg "Garr.jpg").



When I try to edit the graph and select "Plot on x-axis" then access crashes (attached jpeg "Crash.jpg"). When I select "plot as rows" then switch back to "plot as columns" then it works again until I load the form soon after. It seems a bit temperamental.

I've tried repairing, saving/loading as text, switching the queries around.. I'm leaning toward the upgrade being the source of the problems but the upgrade is unavoidable (corporate install) so I'll have to work around it.

Any ideas what could be causing this or, if it is a bug in Access, are there any hotfixes or strategies to work around it? Appreciate any input on the matter.

The query to calculate the times is:

SELECT tblLab_FermentTests.TestID, tblLab_FermentTests.StartBrew, tblLab_FermentTests.SampleDate, tblLab_FermentTests.SampleTime, tblBh_WortCollection.BrewDateFinal, tblBh_WortCollection.BrewTimeFinal, tblBh_Ferments.Brand, Round(([SampleDate]+[SampleTime])-([tblBh_WortCollection].[BrewDateFinal]+[BrewTimeFinal]),2) AS DaysFermented, Round([DaysFermented]*24,2) AS HoursFermented, tblLab_FermentTests.Gravity, tblLab_FermentTests.Temperature, tblLab_FermentTests.FV, tblBh_Ferments.PO
FROM (tblBh_Ferments INNER JOIN tblLab_FermentTests ON tblBh_Ferments.Brew=tblLab_FermentTests.StartBrew) INNER JOIN tblBh_WortCollection ON (tblBh_Ferments.PO=tblBh_WortCollection.PO) AND (tblLab_FermentTests.StartBrew=tblBh_WortCollection.Brew);

The one attached to the graph is:

SELECT qFvSheet.hoursFermented AS Expr1, Max(qFvSheet.Gravity) AS MaxOfGravity, Max(qFvSheet.Temperature) AS MaxOfTemperature
FROM qFvSheet
GROUP BY qFvSheet.hoursFermented;

[Stingaway]

Three things off the top:

1.) Does the query that runs the report run as expected? Do you see all the data points you are looking for?

2.) If 1 is a yes, have you tried re-creating the report that you are using? I tried this recently as I was experience a similar issue and found that half way through recreating mine was actually a data issue in the query - where a conversion was taking place and a grouping in the report was screwy because of bad data.

3.) If this solves the issue, can I bum a pint off of you?

[whatwouldmattdo]

Thanks for the answer Stingaway, sorry for the belated response.. For the record - I think the problem was an access 2007 to 2010 teething issue but seems to have sorted itself. I tried recreating the report but at the time that didn't do the trick, it just seemed to revert back. I guess Graph.exe was screwy.
Anyway thanks for the suggestions - next time you're in Australia I'll definitely sort you out with some pints!

[Stingaway]

I'll hold you to that.