I have an issue in my application. I have created a list Box for a Quarter. But it show an extra value Q,I dont understand why it is showing,I dont have any null date filed.So my question is,how to supress nullvalue in list box?
if any one have any idea please share your suggestion.
Try like this
Properties -> Presentation tab-> Supress null values
Sorry, I thought in chart..
'Q' & ceil(month(Datefield) / 3)
from tablename where Len(Trim(Datefield)) > 0 ;