Yes, that's why you're confused. 😃 If the query returns a text field, then the sort will be on the text, not on the underlying number.
John Viescas, Author
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
On Nov 15, 2016, at 5:29 PM, Phil Knowles firstname.lastname@example.org [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
It is a new field and I have only put values in this field for a few records.
It is a field though that gets its numeric value via a query and in fact displays the related description for that value rather than the numeric value itself - is that why it is confused?
On Tuesday, 15 November 2016, 15:43, "Phil Knowles email@example.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
I am using a form in datasheet mode and one o the fields is numeric.
normally if I select the box at the top of a text field it says
sort a to z
sort z to a
then it gives me a list of all the values that are contained in that field with a check box to be able to select and filter
if I do the same for a numeric field it says
sort smallest to largest
sort largest to smallest
then it gives me a similar list to above
I have a field that is numeric and contains integers
but when I select the box at the top it displays the text version of events and doesn't give me a list of values
any ideas why?
Posted by: John Viescas <firstname.lastname@example.org>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (4)|
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.