<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2722.900" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=408180115-19062003><FONT face=Arial color=#0000ff size=2>Why
not use the Day() function, to just show the day of the month, then split it
into 1 thru 7, etc.</FONT></SPAN></DIV>
<DIV><SPAN class=408180115-19062003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=408180115-19062003><FONT face=Arial color=#0000ff
size=2>Drew</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> ACTEBS
[mailto:actebs@actebs.com.au]<BR><B>Sent:</B> Thursday, June 19, 2003 9:52
AM<BR><B>To:</B> access group<BR><B>Subject:</B> [AccessD] Week of the
Month<BR><BR></FONT></DIV>
<DIV><SPAN class=610101010-19062003><FONT face=Arial
size=2>Guys,</FONT></SPAN></DIV>
<DIV><SPAN class=610101010-19062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=610101010-19062003><FONT face=Arial size=2>Does anyone know
of a method to work out what week it is of the month. For example, you
have a range of dates 1st January to 31st March. The 1st to
the 7th is the 1st week of January and the 8th to the 14th is the second etc
etc...</FONT></SPAN></DIV>
<DIV><SPAN class=610101010-19062003><FONT face=Arial
size=2></FONT></SPAN><SPAN class=610101010-19062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=610101010-19062003><FONT face=Arial size=2>I have 2.5 years
of data (about 1 Million rows) from an old main frame system and we are trying
to determine the frequency of delivery to each customer on a per monthly
basis. So effectively to say customer Jim Spanner the client delivers every
second Thursday for February. Is there an elegant method of working this out?
I have the date the delivery was carried out for the past 2.5 years, but am
having difficulty working out how I could manufacture a frequency pattern.
</FONT></SPAN></DIV>
<DIV><SPAN class=610101010-19062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=610101010-19062003><FONT face=Arial size=2>Is there any
method anyone could suggest, that I could explore...</FONT></SPAN></DIV>
<DIV><SPAN class=610101010-19062003></SPAN> </DIV>
<DIV><SPAN class=610101010-19062003><FONT face=Arial
size=2>AHGA</FONT></SPAN></DIV>
<DIV><SPAN class=610101010-19062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=610101010-19062003><FONT face=Arial
size=2>Regards</FONT></SPAN></DIV>
<DIV><SPAN class=610101010-19062003><FONT face=Arial
size=2>Vlad</FONT></SPAN></DIV>
<DIV align=left><FONT face=Arial size=2></FONT> </DIV>
<DIV> </DIV></BLOCKQUOTE></BODY></HTML>