[AccessD] Greatest Date

If you don’t, or cant, change the table so the dates are stored
seperately you could create a union query which selects each date (with
movie title) as a separate chunk of the union and then use this as the
source of a select max... Etc. same as you would if the dates were in a
single column in a separate table...

Hth

mark

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gowey Mike W
Sent: 05 January 2005 17:57
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

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.827 / Virus Database: 564 - Release Date: 03/01/2005
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.827 / Virus Database: 564 - Release Date: 03/01/2005