RE: Tricky sorting riddle.

Followup to my own message :-) Hi All, I am building a real-estate DB and I have stumbled over an interesting riddle: In this case I use the following fields in Access DB (tenants) Property_ID -integer (related to an ID in Properties table) Name -Text,

Re: Tricky sorting riddle.

Name, DateAdd(MONTH,lease_length,Since) AS sortable_date FROM tenants WHERE Property_ID=#TheRecord.ID# ORDER BY sortable_date /cfquery -Original Message- From: Cyrill Vatomsky [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Monday, May 29, 2000 5:08 PM Subject: RE: T

RE: Tricky sorting riddle.

Have you tried: ... ORDER BY DateAdd(MONTH,lease_length,Since) ??? Good luck, Stephen Followup to my own message :-) Hi All, I am building a real-estate DB and I have stumbled over an interesting riddle: In this case I use the following fields in Access DB (tenants)