Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002
    Location
    Covington, LA
    Posts
    46

    Question Unanswered: query criteria help needed

    hi everyone. this is my first post on this message board. here is what i need help with.

    i have a subform of payments on my payment form. what i need to be able to do is run a query on the available records (payments grouped by [RequestID]) and find the most current date from the field [RecievedDate]. only one value should be selected, and if one is not available, meaning a payment has not been posted, then it should make the null value = 0. what i need to be able to do is calculate the days past due in a textbox. does anyone have an idea on how to do this, or maybe know the criteria to find the highest date in a field?

    thanks form reading my post.
    Unique like everyone else,
    Clark
    -------------------------------------------
    POSTING IS THE TERRIBLE SECRET OF SPACE!

  2. #2
    Join Date
    Nov 2001
    Posts
    336
    Try

    me.txtMexDate = NZ(DMax("RecievedDate]","tblPayments","MemberID=12"),0)

    or if you have MemberID on a form:

    me.txtMexDate = NZ(DMax("RecievedDate]","tblPayments","MemberID=" & Me.txtMemberID),0)

    Igor

Posting Permissions

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