Query won't show alphabetical list

  • Thread starter Thread starter AEWatkins via AccessMonster.com
  • Start date Start date
A

AEWatkins via AccessMonster.com

Simple problem but I can't figure out what I'm doing wrong. I have an
employee lookup list that will not alphabetize. When I use the employee name
table for the row source type, I get the full list but it's not alphabetized.
When I use an alpha query that I created from the same table for the row
source type, I get a blank -- no names, no list.

Do you know what I'm missing? Please let me know if you need more
information.

Thanks.

AEWatkins
New Jersey
 
When I use an alpha query that I created from the same table for the row
source type, I get a blank -- no names, no list.

Do you know what I'm missing? Please let me know if you need more
information.
Click to expand...

There's some error in the query - but we can't tell what without seeing it!

Please open the Query in design view, select View... SQL, and post the SQL
text here. It may help to mention the primary key of the table, its datatype,
and the ColumnCount and ColumnWidths properties of the combo box.

John W. Vinson [MVP]
 
I suspect that you have a lookup field in the table. Does your field in the
query datasheet view have a combobox to choose from? If so, what you see is
not what you get. The field actually has a number (or other primary key)
stored in it and the datasheet view is showing you the linked value.

As an experiment try applying criteria that searches the field by number
(Between 1 and 1000) and see what is returned or if you get an error. One
way to fix the problem is to add the table that contains the real values to
your query. You will need to establish a join between the two tables and to
show the relevant field from the table that has the data.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top