[AccessD] Greatest Date

Move those dates into a separate table so that you have a one to many relationship and can better manipulate the data.

Gowey Mike W <Mike.W.Gowey at doc.state.or.us> wrote:

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




May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us





 





		
---------------------------------
Do you Yahoo!?
 All your favorites on one personal page – Try My Yahoo!