shall we use ORDER BY clause in Ms-Access database? Thanks jegatha mischa kroon <[EMAIL PROTECTED]> wrote: You can use the order by clause in sql for this.
just add: ... order by category, bid_price to your statement. On 7/16/05, Jegatha <[EMAIL PROTECTED]> wrote: > hi > i have 2 fields in my database > 1.category(i have 3 categories web development,design,seo) > 2.bid price > now i should compare both category and prices(lowest) and i should display > the (asending order) number > > any one help to sort out? > > Thanks in Advance, > > Jegatha. > > > --------------------------------- > Too much spam in your inbox? Yahoo! Mail gives you the best spam protection > for FREE! > http://in.mail.yahoo.com > > [Non-text portions of this message have been removed] > > > > > Yahoo! Groups Links > > > > > > > --------------------------------- YAHOO! GROUPS LINKS Visit your group "AspClassicAnyQuestionIsOk" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- Free antispam, antivirus and 1GB to save all your messages Only in Yahoo! Mail: http://in.mail.yahoo.com [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
