> I don't know if MS Access will behave the same, but in MySQL you can > have a query like so: > > SELECT *, DATE_FORMAT(end_date, '%d %m %Y') as end_date_formatted FROM > projects; > > And it will retrieve all columns from your projects table, plus the > extra one you've created on the fly, and it will be named > "end_date_formatted". Great. Thanks, John. Yes, it works for Access as well. Bing -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
