Because u have allowed times in the field then u will have to use one of the following methods

These are part of the where clause :-

dttripstart >= #22/Nov/2000# And dttripstart <#23/Nov/2000#

or

cdate(format(dttripstart,'dd/mmm/yyyy')) = #22/Nov/2000#