Any idea why this query returns all of the rows fine
SELECT Staff.StaffID, Staff.Firstname+' '+Staff.Lastname AS Name, Staff.Role
FROM Staff;
whereas this query returns nothing
SELECT Staff.StaffID, Staff.Firstname+' '+Staff.Lastname AS Name, Staff.Role
FROM Staff
ORDER BY Staff.Priority;
Priority is a simple number field, 1,2,3,….
Only other thing that might be of any relevance is that it did work, I deleted all of the rows then re-inserted them.
(I tried renaming the field in case Access doesn’t like Priority, but it made no difference).
__._,_.___
Posted by: "Bob Phillips" <bob.phillips@dsl.pipex.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar