Query looks ok but access sees error?

[CaliburBlade138]

Hello,



I am now running into an issue when I try to create a basic chart or modern chart based off my query....

This shows that the query is working great..... Got the name I wanted, and the query creates the 2 columns and counts wellAttachment 47518
In a modern chart, all it's showing in the query is the name and not myIndirect count or myOrder count?Attachment 47519

Not sure how to fix this one...?

This is my query now...

PARAMETERS [Forms]![formChart]![Combo0] Text ( 255 );
TRANSFORM Count(*) AS [Count]
SELECT tablemyTimeKeeper.myName
FROM tablemyTimeKeeper
WHERE (((tablemyTimeKeeper.myName)=[Forms]![formChart]![Combo0]))
GROUP BY tablemyTimeKeeper.myName
PIVOT IIf(InStr([myBarcode],"Indirect")>0,"myIndirect","myOrder");

[June7]

You said this was working in your other thread. What is different? Was the other using classic MSGraph? Sorry, I cannot help with Modern Chart.

[CaliburBlade138]

June7,

Yes the query you provided works well. I tried with a classic chart and it says this:

Attachment 47521

[June7]

I don't understand. The query works just fine with classic MSGraph in my test. You said it worked now you say it does not?

[mike60smart]

Hi

Best to upload the database to see if we get the same error.

[CaliburBlade138]

Hey all,

The query works itself, when you select the query to point to from the chart either classic or modern I get the error. I will attach.

Attachment 47522

[June7]

The form combobox errors with 'out of memory'.

I built MSGraph chart on formChart and set the RowSource to querymyTimeKeeper. I select Administrator and when I get the 'out of memory' error, click End. I click Refresh All on ribbon and chart displays correctly.

I got the error you posted when trying to build chart. Because of how MSGraph chart wizard works, I always build a new chart based on a table - any table. Once chart object is established on form or report I change RowSource and chart type and any other properties as needed.

[mike60smart]

Hi
See attached