query won't sort

P

PeterK

I have a table (tbl_BibleBooks) listing the books of the Bible. Fields are:

fld_BibleBooksID (Autonumber)
fld_BibleBooks (Text)

I created a simple query to sort the list alphabetically. Rows as follows:

Field: fld_BibleBooks
Table: tbl_BibleBooks
Sort: Ascending

When I look at the results of the query there is no data. I discovered by
accident that if I remove the sort option the unsorted list of books appears.

Any ideas?
 
J

JerryW

What do you mean by 'there is no data'? Does just one empty row show or is
there a lot of empty rows? You could have records with null values or empty
strings in the fld_BibleBooks field. Try sorting in desending order and see
if records show up.
 
M

[MVP] S.Clark

Sort order, does not affect the rows displayed by the query. Only criteria
can do that. That being said, a filter that is applied to the result set
can cause records to not be displayed.

When you sort, you are actually removing the last applied filter, and
applying a new filter, which all contains instructions to sort.

So, what you are seeing is a Red Herring / Pink Elephant
 
P

PeterK

Ho ho...
Some records have null values, so indeed they are the records sorted at the
top of the list. All is well, and I should have seen that for myself.
Thanks and apologies.
 
Top