DATEPART FUNCTION

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Abul Hasan (abulhasan.lakhani_at_mags.net.pk)
Date: 04/13/04 

Date: Mon, 12 Apr 2004 18:19:33 -0700

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.

Its urgent plz help

Relevant Pages

  • Select Query Help
    ... I want to extract weekly report from access dataabse into recordset. ... Scenario is as follows ... obviously Weeks should be reset when month changes. ... Its urgent plz help ...
    (microsoft.public.vb.database)
  • Select Query Help
    ... I want to extract weekly report from access dataabse into recordset. ... Scenario is as follows ... obviously Weeks should be reset when month changes. ... Its urgent plz help ...
    (microsoft.public.inetserver.asp.db)
  • Re: Reset computer account
    ... Thank you all with good explaination but I am still confused which scenario ... should I use reset instead of add/delete computer in IT ... > the purpose of reset computer account in AD and when to use it. ... > Johnny Chow ...
    (microsoft.public.win2000.active_directory)
  • Re: reset eof and bof flags
    ... you can't reset them, once you reach end or begin of recordset - they will be true, and you can check them any number of times ... how do you reset the eof and bof flags so that they don't error if you ... attempt a movenext or moveprev using a Dao recordset if the eof or bof has ...
    (microsoft.public.access.modulesdaovba)
  • RE: Simultaneously change values in multiple cells?
    ... 1)Set each of the cells that must be reset to zero. ... Name the scenario ...
    (microsoft.public.excel.worksheet.functions)