[AccessD] Greatest Date

I think you should have a seperate table for movie dates.  Have a MovieID
field, and a DateShown field.  Then you can just use the Max function to
show the most recent date the movie was shown (or Min, for the first
date...)

Drew

-----Original Message-----
From: Gowey Mike W [mailto:Mike.W.Gowey at doc.state.or.us]
Sent: Wednesday, January 05, 2005 11:57 AM
To: Access Developers discussion and problem solving
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



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com