Hi Alex I have the same problem as Lone. I'm using a Danish Access 2013. The expression SELECT * FROM ContactT ORDER BY DateTime DESC does not work. Access tells me that I need to put a "=" in front of the expression. When I do that I'm told to but parenthesis around the expression, but that doesn't work either. I also tried getting the field from a seperate query that sorts by date. That doesn't work either. How would one write this SQL in Access 2013?
Sincerely Michael
Reply from Alex Hedley:
Hi Michael, Are you writing this in a Query Builder SQL View? This looks correct, try building the Query graphically and see if that works, you can then change it to SQL View to see what Access has done
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 3.