Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002

    Unanswered: How about this... Help needed!

    I want to find out how many of my members that had a membership for six months or more.

    I got a table with these fields:
    Name, adress, adress2, telephone number, date of membership (the day they sign in)

    I have to fill in the "Now" date.

    I have never used Access before, and I need some examples to find out how the queries work.

    It may be easy for you but for me...

    Jan Iversen

    (I hope you understand the meaning in what I am saying. My english is rather poor)

  2. #2
    Join Date
    Nov 2001
    Try either one.

    SELECT MemberID, DateOfMembership, DateDiff("m",DateOfMembership,Now()) AS DurationInMonths
    FROM tblMembers Where DurationInMonths >= 6;

    SELECT MemberID, DateOfMembership, DateDiff("d",DateOfMembership,Now()) AS DurationInDays
    FROM tblMembers Where DurationInDays >=180;

    6 months = approximately 180 days


Posting Permissions

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