Query sort not sorting...

[jik_ff]

Not a game breaker by any means, but anoying none the less. I have a set of data that tracks keywords, which is also grouped into key groups. The table is formated as such:

ID : autonumber (key field)
KeyGroup : the group name the keyword belongs to
Keyword : the actual keyword.


for instance a bit of the table looks like this:

ID______KeyGroup__________Keyword
3............Actions.....................Cleaning Up
23..........Buildings - Exterior.....Airports
48 Animals....................Amphibians
227 Chemicals.................Biochemicals

and so on for about 400 records. I have made a drop down (combo box) to do a look up of the various Keywords in this table. Since the data is put into this table randomly (meaning not alphabetically) it would be nice to have it sorted. So I created a query base on this table, and set it to Sort Assending on the Keyword field. I run the query, but it does not sort it alphabetically based on the Keyword field. It does some kind of sorting, because viewing the ID column, they are no longer in any sequential order, but (such as with the above 3 records) Biochemials is at the top. Amphibians is about 15 entries down with other words like Inorganic, Monomers, Natural Gas Liquids and more above it. I would understand if it was sorting based off of the other fields, but as with Amphibians, all three fields come before the three fields for ID 227...

Any ideas why this is not sorting?

[alansidman]

See if this helps. If not, post back with a sample data base so it can be analyzed. I suspect that it is sorting on a field other than the keyword field. Also are you doing the lookup in a table or in a form. It should be in a form. Never do a look up in a table.

http://www.datapigtechnologies.com/f...combobox1.html

Why you shouldn't do lookups in a table.

http://access.mvps.org/access/lookupfields.htm

[jik_ff]

Big face palm on my part. Looks like when I imported the table, some of the data had a space in the front.

Sorry for wasting your time...

[alansidman]

No worries. Glad you have solved it.