Working out days from dates in query. 1

[postmanphat]

Hi,

I have a table holding a which items were issued on which date. I'd like to be able to produce a query that tells me how many were issued on Mondays, Tuesdays etc over a certain period.

So, very simplistically my table looks like this:

IssueID ItemID DateIssued

1 1100 10/02/08
2 1250 10/02/08
3 1100 11/02/08
4 1365 11/02/08
...

Hope thats clear... all help is most appreciated

Dave

 

[RivetHed]

Hi,

You should have a look at the Weekday function.

 

[postmanphat]

I should. And I did. And all is good.