« convert this sql qry to access qry?
If you reach into a bag and randomly select one ball from 3 red balls, 8 blue balls and 4 green balls,? »

MS Access Help?

I have a form that includes numerous Bonus codes. I labelled the fields as BC1, BC2, BC3……BC12. ( in the table)

The bonus code is a number and it varies from 100 to 114. After having numerous records, I now want to do a query that will give me all my bonus code entries ( all 12 fields) in ascending order. For example I dont want

100
111
112

100
113
114

I want

100, 100, 111, 112, 113, 114.

Any idea how I can overcome this?? Im think ill have to do a subquery…but im not sure.

SELECT blah
FROM blah
WHERE blah
SORT BY ascending <- this does the trick

This entry was posted on Sunday, December 6th, 2009 at 12:13 pm and is filed under subquery. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “MS Access Help?”

  1. SELECT blah
    FROM blah
    WHERE blah
    SORT BY ascending <- this does the trick
    References :

  2. 2 ways (with Access there is ALWAYS more than one way)..

    Convert Your select Query to a CROSSTAB Query. That is how Crosstabs display data.

    Or build a REPORT that drives off your query that displays the data across instead of down…

    If either of them give you trouble, look them up in the Microsoft Knowledge base.
    References :
    http://support.microsoft.com/

Leave a Reply