how can i short my record by date. my ata using format dd/mm/yyyy. i've been try using deferent metho but not working.

1. how to show just certain date? ex. just data date 10/08/2007
2. how to show just certain range date? ex. just data beetwen 30/10/2006 - 10/08/2007



thanks

See if this link (http://www.mvps.org/access/datetime/date0005.htm) helps a bit.

yes..
I presume you are running your report from a form
ok
in this form put two unbound fields date format ddmmyyy

from and to

now refer to qry date critia to the form
lets say the form name is formA
and the from field is call from and the to field is called to
your qry will have in the date field
Between [forms]![formA]![from] and [forms]![formA]![to]
this allows you any date range


this basical is the same qry but you have made the qry look for the date range