RE: [MS_AccessPros] Query Returns No Results

 

Is Priority a Decimal numeric type?
What happens if you attempt to sort by any other field?
 
Duane Hookom MVP
MS Access
 

---

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Tue, 24 Jun 2014 16:11:17 +0100
Subject: [MS_AccessPros] Query Returns No Results

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: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___