Charts Criteria

[mattP]

Ok, not sure if this is a fix with the report chart or the query, I run a query that captures the last 15 days worth of entries, however currently it counts weekends, which are blank, as such I do not get a full 15 working days worth of data.

This is fine when exporting the data to Excel as the pivot will igonre the date if there is not data, however I have a report chart that includes these weekend dates, so I have some blank columns in my column chart.

Firstly, can I get my query to count working days only, and ignore weekends ? or can I get the cahrt to ignore, not show, blank dates ?

On my query, the date criteris is as follows:

<=Date()-1 And >=Date()-15

Many thanks

MattP

 

[mattP]

Just to add to the earlier entry:

If I run this query today then it will return data from 16th may - 31st May. The query does nto have any results for the 21st or 22nd, 28th, 29th, 30th as these were weekends (and a bank holiday) and therefore there is not data.

Excel creates the graph as expected, however the chart within my MS Access report includes these dates and shows empty columns.

Is this a "feature" of the reporting charts within Access, where they have to include all dates within a date range and cannot ignore dates with no data (or dates that the query has not even produced data for)?

Regards

MattP

 

[mattP]

Can anyone help with this query ?

Thanks

MattP

 

[stevehooley]

Could you apply another query that removes the blank dates, and then run the chart off that?

I'm not too good with charts but I assume that if you have an axis that it time-based and you try and remove days from it, logically it will have problems.