asked on MS Access excluding weekends in graph
Dear Experts,
Is it possible to exclude weekends in a chart. I have a bar chart with dates on the x axis. The data is school data and students do not meet on he weekend so I alway have those two day blank each week taking up space in the chart.
How do exclude weekend dates?
Is it possible to exclude weekends in a chart. I have a bar chart with dates on the x axis. The data is school data and students do not meet on he weekend so I alway have those two day blank each week taking up space in the chart.
How do exclude weekend dates?
Microsoft Access
Last Comment
Scott McDaniel (EE MVE )
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Depends on what sort of Chart you created, and how you created it, but essentially just recreate the chart using the query you built earlier.
ASKER
Scott,
Here's the thing... when I use the SQL you provided the weekends are excluded in the query but when I display the value in the chart I still get Saturday and Sunday date but without data.
![using sql]()
However, when I remove the SQL statement the data shows up:
![without sql]()
So I guess what I am seeking is a way to not have the weekends show up on the x axis of the chart. Is that even possible?
Here's the thing... when I use the SQL you provided the weekends are excluded in the query but when I display the value in the chart I still get Saturday and Sunday date but without data.
However, when I remove the SQL statement the data shows up:
So I guess what I am seeking is a way to not have the weekends show up on the x axis of the chart. Is that even possible?
I'm not quite sure I follow you ...
When you create a chart in Access, you're asked to choose a Table or Query on which to base your chart. If you do that, and choose the query that excludes weekend dates, your resultant chart should show only the values in your query (i.e. the WeekDays).
Or perhaps I'm missing something.
When you create a chart in Access, you're asked to choose a Table or Query on which to base your chart. If you do that, and choose the query that excludes weekend dates, your resultant chart should show only the values in your query (i.e. the WeekDays).
Or perhaps I'm missing something.
Thanks! So I tried this on the record source of the Chart and it worked in the sense that data is not showing up on Sat and Sun but how to I remove those dates from showing up on the x axis of the access chart? right now I have Sat and Sun for each week but no data.
Thanks!