Hi, This one has been bugging me
This is my query

SELECT DISTINCTROW Format$(TimeSheet.Date,'ww yyyy',4) AS [Week Ending],
TimeSheet.Employee, Sum(TimeSheet.Units) AS [Sum Of Units], Count(*) AS
[Count Of TimeSheet]
FROM Employees INNER JOIN TimeSheet ON Employees.EmployeeID = TimeSheet.
Employee
WHERE (((TimeSheet.Date)>=[forms]![Startup]![1sttsent] And (TimeSheet.Date)<=
[Forms]![startup]![wkedng]) AND ((([TimeSheet].[Code]))<>24))
GROUP BY Format$(TimeSheet.Date,'ww yyyy',4), TimeSheet.Employee;

It show  the info i want.
Except for the Column (Week Ending), it displays the following

Week Ending
23 2006
24 2006 etc

Thou i want it to Display

Week Ending
04/06/2006
11/06/2006
18/06/2006

i have this query in a form.  Now i don't care if it is displayed ( 23 2006)
in query.  But i want to display it as ( 11/06/2006 ) in the form.  Can
anyone help me with this?

Thanks