Label Dependant upon Graph having data

AccessQuestions

Registered User.
Local time
Today, 08:33
Joined
Jan 13, 2014
Messages
15
I created a number of graphs on forms that graph GamesSold vs RDate. If a game has no sales, there won't be any data. Is there a way I can add a label that will automatically display "Game is not yet released" and make it dependant upon the graph having data, and invisible if it does? I appreciate any help.
 
Alternatively, If i could make the graph invisible, I could just have a message behind each one, that would then be visible. Please let me know if you know how I can accomplish this.
 
Ok, I figured this one out. If i base the graphs off a query - I can simply use a DCount to find out if there are any records in a key field that would show up. Extra criteria can be added to the DCount as well:

=IIf(DCount("[SumField1]","Query","Criteria")=0,"No Data Month to Date",Null)

Then i set the box to "can shrink" so it will disappear if there is Data.
 

Users who are viewing this thread

Back
Top Bottom