Link to home
Start Free TrialLog in
Avatar of Mike Rudolph
Mike RudolphFlag for United States of America

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?
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mike Rudolph

ASKER

Scott,

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!
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.
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.
User generated image
However, when I remove the SQL statement the data shows up:
User generated image
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.