Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Oct 2001
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    calc days since a date (access xp)

    I have a form (frmDistributors) with a text box within which I would like to create an expression to display the days since the current distributor placed an order (something like now()-podate)...but only for the most recent podate. That necessary data is in tblSales and I have a similar expression for total orders for a distributor =DCount("UnitsSold","tblSales","Distributorid= " & [Distributorid]) but I can't seem to figure out how to use only the most recent po date. thank you for any help. scott

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: calc days since a date (access xp)

    Use the DMax function.
    Pat <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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