Forum Discussion
Help with MS Access query to return Brand sold 1 year after purchase date
amasikonde
Is this what you want?
amasikonde What do you actually want to see as "brand sold"? A count of each brand? A simple list of unique brands? Or....?
Also what is the meaning of "PurchaseDate"? What is the meaning of "SoldDate"?
Are you buying and selling cars?Do you want a count of cars purchased and also sold within a year or less of the date they were purchased as opposed to cars still held one year or later?
This being a car dealership business, the "Purchase Date" is the date when the business bought the merchandise/vehicle and "Sold Date" is when the Vehicle was sold. George Hepworth
I would love the query to return the brand name, price, and the date soldGeorge Hepworth
I just want to see the Brand name and dates of all vehicles sold George Hepworth
amasikonde
Is this what you want?Thank you so much that worked. I am very new when it comes to Access, and I have to use it for now. Is it possible to use the same approach to get data of vehicles less than six months after purchase date? George Hepworth
