Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2002
    Posts
    35

    Unanswered: Working with Dates

    Here is my question.

    I have a database of clients that have purchased items in the past 2 years. Anyone who has purchased an item in the during the past 3 months is considered "Active", all the other clients are considered "Inactive".

    What would be the criteria for a query to get me the list of "Inactive"?

    The relevant fields are date and client number.

    Please help, Thanks.

  2. #2
    Join Date
    Feb 2002
    Location
    San Antonio, TX
    Posts
    69
    <Now()-90
    "Doing stuff is overrated. Take Hitler for example. He did lots but don't we all wish he'd have just stayed home and gotten stoned?"

  3. #3
    Join Date
    Jul 2002
    Posts
    35
    <Now()-90

    will get me all the customers that are in the database that are older than 90 days, but what if they did purchase something in the previous 3 months?

    I need unique records. Any suggestions, Thanks

  4. #4
    Join Date
    Jul 2002
    Posts
    35
    OK, I figured it out, thanks for the help.

    In case you are interested.

    I created a query that got me all the current clients.
    >Now()-90
    And then I did a unmatched query, which would give me everyone that did not appear in the current clients query.

    A little messy, but it does the job.

    Parra

Posting Permissions

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