Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2002
    Posts
    132
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date of Last Entry (Access 2000)

    I want to format a textbox on a report to show the last date of the queryed data.

    Right now the control source is samplepickedup.

    Is there any funtion to do that?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Date of Last Entry (Access 2000)

    I'm not sure I understand, but perhaps this will do what you want (assuming that samplepickedup is a date field):
    - Set the control source to

    =Max([samplepickedup])

    - Change the name to something else than samplepickedup

Posting Permissions

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