Forum Discussion
amasikonde
Jul 14, 2020Copper Contributor
Help with MS Access query to return Brand sold 1 year after purchase date
I'm having problem writing a query to return Brands of vehicles sold in less than 1 year from the purchase date. The data I'm using is as shown below. Brand Price Body Mileage EngineV Engine...
- Jul 14, 2020
amasikonde
Is this what you want?
George Hepworth
Steel Contributor
amasikonde What do you actually want to see as "brand sold"? A count of each brand? A simple list of unique brands? Or....?
George Hepworth
Jul 14, 2020Steel Contributor
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?
- amasikondeJul 14, 2020Copper Contributor
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
- amasikondeJul 14, 2020Copper Contributor
I would love the query to return the brand name, price, and the date soldGeorge Hepworth