Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Posts
    12

    Question Unanswered: reg: date variable

    hi ,
    i have a date field with 50 records.I need to report the latest date alone in the header of the report with some other fields.can anyone please let me know how.
    i tried giving "=max(last update) "where last update is the name of the field.
    Thank you
    Asif

  2. #2
    Join Date
    Mar 2003
    Location
    London
    Posts
    40

    Re: reg: date variable

    Originally posted by mdasif
    hi ,
    i have a date field with 50 records.I need to report the latest date alone in the header of the report with some other fields.can anyone please let me know how.
    i tried giving "=max(last update) "where last update is the name of the field.
    Thank you
    Asif
    =dmax("[last update]", "[your table name]")

  3. #3
    Join Date
    Oct 2002
    Posts
    12

    Smile Re: reg: date variable

    thank you for your immediate reply.
    initially i tried to implement this in the section header ,it gave me error,now i tried putting it in the report header it worked fine with the =max([last update])
    Thank you.
    asif

    Originally posted by yk58301
    =dmax("[last update]", "[your table name]")

Posting Permissions

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