Hello Friends,
I am trying to build a query for a Stocks Buy/Sale Records.
Here are the Fields of query that i built.
Date (Date when stock is Bought or Sold)
PersonalID (Person who Bought or Sold)
Company (Company whose Stock is Bought or Sold)
Quantity (Quantity Bought or Sold)
Price (Price at which it is Bought or Sold)
TaType (Buy or Sale)
Now I want to build a query which should give me result of Single Person who has Sold the Stocks of the Companies with Date of Purchase & Sale Records.
It should Exclude records of Purchase.
Please help am kind of new to complex queries and these seems complex to me...