Abul Hasan wrote:Is that the source data or the desired results?> Hello everyone,
> I want to extract weekly report from access dataabse into recordset.
> Scenario is as follows
> WEEK Number of SMS
> 1 50
> 2 25
> 3 30
> obviously Weeks should be reset when month changes.
You have not given us enough information. Please try again. When asking for
help with a query, you should provide us with a few rows of sample data in
tabular format (just the relevant columns - use the smallest number of
columns required to illustrate the problem), followed by the results you
wish to obtain from that sample data, again in tabular format.
We need to know what is meant by "reset" and how we should know when the
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.