I currently have a table where i have data in a field which is date and timestamped: i.e. 11/06/2005 16:15:15 There are several entries for each day and what i require is to execute a qury which creates a table with only the date selected showing

I have tried the following in the query:

Date: DatePart("m",[Car_Despatch]) & "/" & DatePart("d",[Car_despatch]) & "/" & DatePart("yyyy",[Car_despatch])

When i select a date in the criteria i get a blank table.


Can anyone suggest how i resolve this

The answer to ur question would be found on Beginning Access 2K2 VBA from wrox press.The function "DatePart takes four arguments, two of which are optional:

       DatePart(Interval, Date [, FirstDayOfWeek [, FirstWeekOfYear]])

Interval identifies which part of the date to return."

I would try "d" if i have wanted the days on a query. So try using the above
function on the grid of ur query.
rgds Penta