Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Location
    Brooklyn
    Posts
    25

    Unanswered: CurrentMont, Last Month accts

    Hello,
    I have a table which that include fields below:
    ************************************************** ********
    AcctNum, AeName, RecDate, Date Active, Date Follow Up, Status Code
    ************************************************** ********
    1 Roger 4/17/2006 6/12/2006 5/10/2006 Active
    2 Roger 11/20/2006 12/4/2006 Not Active
    3 Roger 1/5/2007 2/2/2007 1/19/2007 Active
    4 Lynda 2/1/2007 Not Active
    5 Lynda 12/21/2006 1/11/2007 DoNotRgstr
    6 Lynda 11/15/2006 12/1/2006 DoNotRgstr

    I need your help to write a query, that based on AeName and Date Active will return how many as per each AeName accts are active between current month and last month, current month and last two monthes, Based on DateFollow Up, will return how many accts are still Not Active and how many set Do not Rgstr between current month and last month, current month and last two monthes.


    Thank you so much

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    I need your help to write a query, that based on AeName and Date Active will return how many as per each AeName accts are active between current month and last month, current month and last two monthes, Based on DateFollow Up, will return how many accts are still Not Active and how many set Do not Rgstr between current month and last month, current month and last two monthes.
    wow... that's a mouthful

    Based on the data you've provided, what would you expect your result set(s) to look like?
    Inspiration Through Fermentation

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •