By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,489 Members | 1,777 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,489 IT Pros & Developers. It's quick & easy.

Sort Order Commands not working

100+
P: 418
Row Source for a Combo Box, I have this
Expand|Select|Wrap|Line Numbers
  1. SELECT 0 as VendorID, "<ALL>" as VendorName
  2. FROM tblzNull
  3. UNION ALL
  4. SELECT tblVendors.VendorID, tblVendors.VendorName
  5. FROM tblVendors;
This works fine.

I need to have the list sorted by ascending order. But I couldn't get it to work successfully no matter where I put "ORDER by"

Any help from anyone? Thanks.
May 4 '09 #1
Share this Question
Share on Google+
5 Replies


FishVal
Expert 2.5K+
P: 2,653
Sorry, but where did you try to "put ORDER BY" so far?

Kind regards,
Fish.
May 4 '09 #2

100+
P: 418
before the word FROM tblVendors
May 4 '09 #3

FishVal
Expert 2.5K+
P: 2,653
What about reading Access help first before making intuitive coding? :)
May 4 '09 #4

100+
P: 418
Thanks for your suggestion.
May 4 '09 #5

NeoPa
Expert Mod 15k+
P: 31,709
Jet SQL can be quite hard to find Help on. Here's a link that should help you find this, quite invaluable, resource (Finding Jet SQL Help).

Let us know the solution when you find it M, or that you couldn't if that's the case. We'll help if required.
May 5 '09 #6

Post your reply

Sign in to post your reply or Sign up for a free account.