Forum Discussion
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...
amasikonde
Is this what you want?
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
