Graph Not Displaying Dates Without Data

[skilche1]

When creating a graph, how do I not show the graph that contains no data? As it stands now, when I do a search using a date criteria, it shows all the days of the week. Those including days without data. How do I get rid of the days without data?

Thanks,

Steve

 

[Rich]

Not Is Null in the criteria of the date field in the Graphs underlying query

 

[skilche1]

Not Is Null in the criteria of the date field in the Graphs underlying query

Thanks Rich,

That wouldn't be "Is Not Null"? I have tried this method and to no prevail. I will try your suggestion based on your reply.

Thanks again,

Steve

 

[skilche1]

Just tried the way you said Rich "Not Is Null" and it's a no-go. Same results...

hmmmmm, any other ideas?

Thanks

 

[boblarson]

You need to set your nulls to zeros in the query.

 

[skilche1]

You need to set your nulls to zeros in the query.

Never did that. How do you go about doing that bob?

Thanks (as usual)

 

[Rich]

What is the data type?

 

[skilche1]

short date - "Expr1: (Format([Date],"Short Date"))". This is taken from the Chart sql.

Date data type in the Table is "mm/dd/yyyy"

Hope this helps.

Thanks

 

[boblarson]

Actually, I misread the question. I thought that you WANTED the days without data to show up, when in fact you are getting that and DO NOT want the days without data to show up. My previous advice is therefore flawed and not valid.

I'm not sure, but you would probably need to change the graph's axis option for what to include. I don't have a graph to be able to check to see how to do that, but it should be available somehow.

 

[Rich]

If you put 0s in a date field, it'll display as 1890, try IsDate in the criteria, and there are no quotes surrounding Not Is Null criteria. Also try removing the Format function from the query first

 

[skilche1]

OK, I have tried and just cannot seem to get it. Perhaps if you were to take a look at the file?

Got to "W-GraphSearch" ---> in the Forum Category, then select "Chart by Day" via the dropdown and run search, there you will see the Chart and mayber you'll have a better idea.

thanks

 

[Rich]

Can't unless it's a 97ver

 

[skilche1]

not sure if I follow. I am using MS Access 2003. <shrug>