J
Jeff C
I am building some automated reports based on the values in a linked DBase
Table. The DBase columns are labeled "ONE" thru "THIRTYONE" for each day of
the month. The values returned for each day are either 0, 100 or null. I am
trying to differentiate between a null because the day is in the future and a
null because there was no value entered that day.
I thought if there was some way to relate each of the DBase columns to a
separate table that had a true date value for each day of the month I could
build an expression to return two different strings for the null based on the
future date.
Is my question clear? Any ideas?
Thank you
Jeff C
Live Well .. Be Happy In All You Do
Table. The DBase columns are labeled "ONE" thru "THIRTYONE" for each day of
the month. The values returned for each day are either 0, 100 or null. I am
trying to differentiate between a null because the day is in the future and a
null because there was no value entered that day.
I thought if there was some way to relate each of the DBase columns to a
separate table that had a true date value for each day of the month I could
build an expression to return two different strings for the null based on the
future date.
Is my question clear? Any ideas?
Thank you
Jeff C
Live Well .. Be Happy In All You Do