Count By week
  Home FAQ Contact Sign in
microsoft.public.access only
 
Advanced search
POPULAR GROUPS

more...

 Up
Count By week         

Group: microsoft.public.access · Group Profile
Author: joe
Date: Jun 12, 2008 09:00

I have a table which has the Order #, name address and the date when the
order was placed.
I need to get a count of orders by week. My week is from Mon through Sun , I
also need the date of the Monday of the week

Example
Order # Name Address Date
1234 John 123 Main street 06/09/08
9889 fdlkjdfklj ljdljflfljdfl 06/10/08

The results I am looking for is like

Week Starting Count
)6/09/08 2

You guys have been of great help, thanks in advance for your help
1 Comment
diggit! del.icio.us! reddit!