R
Regan via AccessMonster.com
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].
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