Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Distinct on one field, showing all fields
At first glance that doesn't appear that it will work out. Maybe if I adjust a few items on it I can get it to work the way I need it to. I did find a work around for now. Each team has an "OrgID" so I added in there, where ((Schools_1.OrgID)>[Schedule].[OrgID])); SELECT Schedule.[Date...- krkearney
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Distinct on one field, showing all fields
I need to show all records, but use the distinct function on only one field. I have been searching around and I have seen on some sites that there is a SELECT DISTINCT ON function, but this doesn't seem to work with access. This is for a football schedule database I have been working on. The...- krkearney
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
