Solved Stacked Column with Date Range (1 Viewer)

SalahElshafie

New member
Local time
Today, 11:14
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: 12

arnelgp

error reading drive A:
Local time
Today, 17:14
Joined
May 7, 2009
Messages
11,153
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: 10

SalahElshafie

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

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

arnelgp

error reading drive A:
Local time
Today, 17:14
Joined
May 7, 2009
Messages
11,153
here is your Access Chart.
See the code of the button on Form1.
 

Attachments

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

Users who are viewing this thread

Top Bottom