Hi all
Im using a graph on a form
the graph plots quantity against dates
the gaphs table has some null values against dates
im using a line graph and the line tends to join all the dates regardless that the value is null
i want the line to stop where nulls exist and start again at the nearest value..
can i do this... i dont want to replace the null with a 0 - because the nulls provide different info to users..
thanks
Im using a graph on a form
the graph plots quantity against dates
the gaphs table has some null values against dates
im using a line graph and the line tends to join all the dates regardless that the value is null
i want the line to stop where nulls exist and start again at the nearest value..
can i do this... i dont want to replace the null with a 0 - because the nulls provide different info to users..
thanks