Problem in Stacked Column (1 Viewer)

SalahElshafie

New member
Local time
Today, 19:04
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

  • Problem.png
    Problem.png
    98 KB · Views: 119
  • Test Chart.accdb
    544 KB · Views: 270

June7

AWF VIP
Local time
Today, 09:04
Joined
Mar 9, 2014
Messages
5,423
There is no chart and no VBA code in that db. There is only a button embedded macro to open form.
 

SalahElshafie

New member
Local time
Today, 19:04
Joined
Oct 23, 2020
Messages
17
Please how can be select variation date from txt boxes then chart is show
what is wrong on the expression

Between [Forms]![Form1]![txtStartDate] And [Forms]![Form1]![txtEndDate]
 

Attachments

  • Problem.png
    Problem.png
    98 KB · Views: 264
  • Test Chart.accdb
    720 KB · Views: 270

June7

AWF VIP
Local time
Today, 09:04
Joined
Mar 9, 2014
Messages
5,423
Again, no chart and no code.

The queries work. Without chart and code, nothing to analyze.
 

SalahElshafie

New member
Local time
Today, 19:04
Joined
Oct 23, 2020
Messages
17
PLease Ca be modify your solving on attached.
Sorry i am beginner in access.
 

Users who are viewing this thread

Top Bottom