Results 1 to 2 of 2
  1. #1
    adrian is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Dec 2013
    Posts
    1

    Dynamic Query

    Hi, I'm using an access Database for an ISP and I would like to make a dynamic query that will lists me all clients that are at the end of the date, and if there is any client that didn't pays for more than one month to list the total of his sum.



    Thanks a lot!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,445
    Not knowing your data structure, hard to be specific.

    What is the date referenced in 'end of the date' - a membership expiration or something like that?

    Maybe something like the following:

    SELECT * FROM tablename WHERE [date field] <= Date();

    SELECT clientID, Sum(invoices) - Sum(payments) As Total FROM [table or query name] WHERE [payment date] <= DateAdd("m",-1,Date()) GROUP BY clientID;
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Dynamic dates with query
    By unslog in forum Access
    Replies: 2
    Last Post: 03-23-2012, 07:27 AM
  2. Dynamic Form, Dynamic labels/ captions?
    By JFo in forum Programming
    Replies: 15
    Last Post: 10-12-2011, 08:33 PM
  3. Replies: 1
    Last Post: 07-30-2010, 10:28 AM
  4. Dynamic Query
    By pushpm in forum Queries
    Replies: 0
    Last Post: 04-22-2009, 12:58 PM
  5. Dynamic SQL Query
    By Squeaner in forum Queries
    Replies: 0
    Last Post: 09-25-2008, 02:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums