Solved Stacked Column with Date Range (1 Viewer)

SalahElshafie

New member
Local time
Today, 21:34
Joined
Oct 23, 2020
Messages
17
Hi,
my project test is drawing stacked column, i created stacked column in [frmSafeAct] Between (x-Category ) Action Reference , (Y-Category) Unsafe Act Count and (Legend Series) is Unsafe Act (Positive and negative).
It is done easy.
But when create new query with expression date range, the problem is occurs and dont drawing. and start the attached message.

Attached test chart.
 

Attachments

  • Test Chart.accdb
    544 KB · Views: 238

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 03:34
Joined
May 7, 2009
Messages
19,169
i am having error on your Parametered Query, it won't display on the Graph.
i made my own (using Excel).
you can change the dates in Form2 and it will be reflected on the Chart.
 

Attachments

  • Test Chart (1).zip
    80 KB · Views: 196

SalahElshafie

New member
Local time
Today, 21:34
Joined
Oct 23, 2020
Messages
17
Thanks for you efforts

Can be change paramatrized qurey and using it, instead of Excel sheet?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 03:34
Joined
May 7, 2009
Messages
19,169
here is your Access Chart.
See the code of the button on Form1.
 

Attachments

  • Test Chart (1).zip
    82.2 KB · Views: 264

Users who are viewing this thread

Top Bottom