Hi Folks
I have a simple table that has a date field.
This is called dateopened and is in the format ddmmyy hh:m
I have a query based on this table.
What I'm trying to do is workout the day that a case was opened from the date entered.
i.e I have an entry that was opened on 10/08/06
My calculated filed works out that this was raised on a Thursday ?
I can then do dcounts etc on how many cases were opened on a Thursday or a Friday etc
I cant really get my head around the syntax in the query fileld
Can anyone advise me how to do this ?
Many thanks
Jimmy
I have a simple table that has a date field.
This is called dateopened and is in the format ddmmyy hh:m
I have a query based on this table.
What I'm trying to do is workout the day that a case was opened from the date entered.
i.e I have an entry that was opened on 10/08/06
My calculated filed works out that this was raised on a Thursday ?
I can then do dcounts etc on how many cases were opened on a Thursday or a Friday etc
I cant really get my head around the syntax in the query fileld
Can anyone advise me how to do this ?
Many thanks
Jimmy