I use Access XP.
I have a single table called Movies containing the following fields:
ID, Title, Genre, Rating, Location, Date
I want a datasheet with the Titles that have a date sorted in Descending order by date, then the Titles that don't have a date sorted by Title in Ascending order.
I have this:
Expand|Select|Wrap|Line Numbers
- SELECT [Title] & " " & "(" & [Rating] & ")" AS Expr1
- FROM Movies
- WHERE (((Movies.Date) Is Not Null) AND ((Movies.Genre)="Drama"))
- ORDER BY Movies.Date DESC
- UNION ALL
- SELECT [Title] & " " & "(" & [Rating] & ")" AS Expr1
- FROM Movies
- WHERE (((Movies.Date) Is Null) AND (((Movies.Genre)="Drama"))
- ORDER BY Movies.Date ASC;
What am I doing wrong?
Thanks,
Chuck