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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Creating a query that shows only one line for each product
It all sounds a bit more complicated than what I was after. I just need to know the products that haven't sold in the last six months so that I can get rid of them and stock more stuff that does sell. If I got a report on each product and the date they sold I could just search through the list...- LisaT
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Creating a query that shows only one line for each product
I have a sales database which records sales. I want to be able to get a list of all the products and the date the product was last sold. What I have been able to do is to get a list of all the products and the dates that they were sold but it shows every instance of the product and each date...- LisaT
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
