[AccessD] Greatest Date

Mike,

    Apparently, you wish to compute the maximum of date values across the columns, for a given record. You might be able to get some working ideas from my sample db named ComputeAcrossFields, available at Rogers Access Library (other developers section), does something similar for numeric fields. Link -
http://www.rogersaccesslibrary.com    

    The underlying approach could be adapted suitably for your specific needs.

A.D.Tejpal
--------------

  ----- Original Message ----- 
  From: Gowey Mike W 
  To: Access Developers discussion and problem solving 
  Sent: Wednesday, January 05, 2005 23:27
  Subject: [AccessD] Greatest Date 

  I have a database that has a table that contains the title of a movie and than has 6 date fields for entering a date that the movie was shown.
  I would like to be able to extract the title of the movie and only show the date field with the greatest date.

  Any help would be greatly appreciated.

  Thanks in advance

  Mike Gowey  MCP, A+, LME, NET+
  Team Leader - East Region
  Information Systems Unit