Hi, please see the report in the database attached.
Can anyone let me know why the left hand column is empty? And how I fix this issue?
Any help appreciated.
Kirsti
Hi, please see the report in the database attached.
Can anyone let me know why the left hand column is empty? And how I fix this issue?
Any help appreciated.
Kirsti
Need the data to test graph.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Hi June,
The chart is based on the queries: TTRS2_YTD2 and TTRS2_YTD4
The tables are links to another db (backend?). Don't have data in the posted db.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Apologies. Try this one.
You have records with no value in Mediation Outcome and Tribunal Outcome. These Nulls do not show. Handle the Nulls with Nz in the query.
Tribunal Outcome: Nz([Tribunal_Outcome_TT],"None")
Or Exclude the Null records with criteria: Not Is Null
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks for your input June,
The issue I have is that I need those records with no value in the Mediation and Tribunal Outcomes. Reason being that I have the Housing_Officer table in the query as a way to ensure that a name will appear in the chart series, even if they have no Mediation or Tribunal Outcomes against their name.
So, I tried as you suggested, but that still has an empty column on the chart with an axis label of "none". And if I exclude the records with Null value, I loose the names of the Housing Officers that I need to appear in the chart legend.
Yes that is a conundrum. The blank has to show somewhere. You could use Count instead of Sum and show bars on the graph for the None value.
Correct my earlier statement. The Nulls are showing in the graph. That is the lefthand space with no caption and sums of 0.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks June,
I found this code, obviously it is written for charts in excel, and as you know I know nothing about VBA! But would it be possible to manipulate this code to use it within the report?
Delete or Remove Empty Columns
Description: Use this macro to delete/remove empty/blank columns with in the Selection.
Code: Sub DelBlankColumns()
' Deletes all empty columns on the active worksheet
Dim iCol As Integer
With ActiveSheet.UsedRange
For iCol = .Column + .Columns.count - 1 To 1 Step -1
If IsEmpty(Cells(65536, iCol)) And IsEmpty(Cells(1, iCol)) Then
If Cells(65536, iCol).End(xlUp).Row = 1 Then
Columns(iCol).Delete
End If
End If
Next iCol
End With
End Sub
No - this code is actually removing a column of cells from the worksheet, thereby removing blank cells from the data range so they aren't represented in the plot.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Ah, ok. Thanks - I will keep looking!