Sort Query Results

[vladimir.mcbadger]

Hi,

I use the following SQL to generate a histogram type query - i.e.
results are banded into

Critical, High,medium and low across one acis and age is banded across
another axis. As the bands are uneven I have used a table called
"intervals" to define the intervals. Everything was fine until today
when the table re-sorted itself and the Y axis (time intervals) is no
longer in a logical order.

I hope this makes sense - any idea on how you could re-order the y
axis.

I have tried the normal right click - sort ascending and this does not
work.

TIA

Vlad

 

[Jerry Whittle]

Tables have no order. Access makes it look that way; however, it can also
change things around at a whim.

If you want to view your records in a certain order, you need to do it in a
query and sort the field(s) in question. If those fields don't sort as you
wish, you need to create a number field in the table and manually number the
fields in the way that you wish to see the records. Then in a query sort on
that field.