Find out how many monday between two dates

[dorling]

i basic need to find out how many monday (or tueday etc) there as been in between two date.

for example

12/08/04 to the 16/09/04 there was 5 monday.

the date are in a table and i need the number of monday(or tueday) in a query so i can use it to work how the cost of items that only happen on mondays

thanks in advance

Jonathan D

 

[MichaelRed]

Please do not post redundantly. It resembles "SPAM" and is often Unwelcome!





MichaelRed
mlred@verizon.net

 

[dorling]

there is only 1 othere and that was pick the pick not how many there was aka a int

thanks in advance

Jonathan D