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!
-
Return distinct query with some non-distinct columns
Thanks Leslie that seems to do the trick. I modified it a bit to MAX on the BidAmount instead of bidTime, but it seems to work fluently. One more question... I am developing this on Access, since it is relatively simple and doesn't require account permissions on our servers here. In a few...- delphi319
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Return distinct query with some non-distinct columns
Hello All... I hope this is doable, as it would make my life much easier right now. I am writing a simple auction site for a charity auction at our company. I have a table called "Bids" that includes the Bid entries for a given Item. The table includes the following cols: -bidID (PK) -itemID...- delphi319
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
