I have an Access 2010 database in which I am having issues to isolate the text date from the string and sort the records by the text date.
Table: Movie
Column: Title
Data type: Text
Sample table data:
12 Years A Slave (2013-R)
127 Hours (2010-R)
17 Again (2009-PG13)
21 (2008-PG13)
27 Dresses (2011-PG13)
Here is the query I am working with:
SELECT Movie.Title AS movieyear, movie.title
FROM Movie
WHERE (((movie.title) Like '*20##*'))
ORDER BY movieyear, desc;
The query results I would like to see:
12 Years A Slave (2013-R)
27 Dresses (2011-PG13)
127 Hours (2010-R)
17 Again (2009-PG13)
21 (2008-PG13)
Table: Movie
Column: Title
Data type: Text
Sample table data:
12 Years A Slave (2013-R)
127 Hours (2010-R)
17 Again (2009-PG13)
21 (2008-PG13)
27 Dresses (2011-PG13)
Here is the query I am working with:
SELECT Movie.Title AS movieyear, movie.title
FROM Movie
WHERE (((movie.title) Like '*20##*'))
ORDER BY movieyear, desc;
The query results I would like to see:
12 Years A Slave (2013-R)
27 Dresses (2011-PG13)
127 Hours (2010-R)
17 Again (2009-PG13)
21 (2008-PG13)