digitalshepard
Registered User.
- Local time
- Today, 17:57
- Joined
- Jul 20, 2011
- Messages
- 32
As many of you are likely aware, Access has a [Select TOP] feature but does not have a [Select BOTTOM] feature. Very annoying.
The work around I used had a query which sorted a field in descending order [ORDER BY table.Field DESC], and another query which used a [Select Top 10] and a [ORDER BY table.Field ASC]. This worked great in Windows XP with Access 2003, but breaks with Windows 7 and Access 2003. Back to square one.
Any ideas how I can [Select BOTTOM] that doesn't break in Win7?
The work around I used had a query which sorted a field in descending order [ORDER BY table.Field DESC], and another query which used a [Select Top 10] and a [ORDER BY table.Field ASC]. This worked great in Windows XP with Access 2003, but breaks with Windows 7 and Access 2003. Back to square one.
Any ideas how I can [Select BOTTOM] that doesn't break in Win7?