when i removed hours form timestamp field
when i put hours in list box they are repeating in want only the distinct hours in the listbox
can anyone help me?
thanx in advance
Hour(TimestampField) as HourField,
instead of (assumed) formatting using Date() or Time() function, like Time(TimeStampField, 'hh')
Retrieving data ...