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!
-
Remove repeating data in query....
Its the smallest from the date difference between date1 and date3. Thanks.- pwynne33
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Remove repeating data in query....
Sequencer? (Sorry if I sound dumb)- pwynne33
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Remove repeating data in query....
I've got a query that displays ID No - Date1 - Date2 - Diff from Date1 to Date2 - Date3 - Diff from Date1 to Date3 However for each ID No there are more than one record in this query. I'd like to just show the first record for each ID No instead of displaying all the records with that ID no...- pwynne33
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
