Sorting by dates in adp project

G

Glint

I am still having problems sorting my forms by date in an Access Project. The
filter:
Me.Filter = "[TDate]>=" & "'" & Starting & "'" & " And [TDate]<=" & "'" &
Ending & "'"
works in some forms but not in others. [Starting] and [Ending] are unbound
textboxes set to date data type.

2. An unbound textbox with control source=Sum([Amount]) would return the sum
of the [Amount] returned by the filter. But in the adp file, I have observed
it performs differently. Is there a way to get the sum without adding so much
code?

Thanks in advance.
 
Top